you can just google it, plenty of stuff out there like...
... which retrieves responsibilities for a specific user.Code:SELECT b.responsibility_name NAME FROM apps.fnd_user_resp_groups a, apps.fnd_responsibility_vl b, apps.fnd_user u WHERE a.user_id = u.user_id AND u.user_id = &p_user_id AND a.responsibility_id = b.responsibility_id AND a.responsibility_application_id = b.application_id AND SYSDATE BETWEEN a.start_date AND NVL (a.end_date, SYSDATE + 1) AND b.end_date IS NULL AND u.end_date IS NULL




Reply With Quote