eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PE_USERID_PKG dependencies on FND_USER_RESP_GROUPS_DIRECT

Line 1347: CURSOR c_get_assigned_resp (cp_user_id fnd_user_resp_groups_direct.user_id%TYPE,

1343: AND ap.application_id =rsp.application_id
1344: AND ap.application_short_name = st.application_short_name;
1345:
1346: -- Cursor to check whether a particular responsibility is assigned to a person
1347: CURSOR c_get_assigned_resp (cp_user_id fnd_user_resp_groups_direct.user_id%TYPE,
1348: cp_responsibility_id fnd_user_resp_groups_direct.responsibility_id%TYPE,
1349: cp_resp_app_id fnd_user_resp_groups_direct.responsibility_application_id%TYPE) IS
1350: SELECT responsibility_id
1351: FROM fnd_user_resp_groups_direct

Line 1348: cp_responsibility_id fnd_user_resp_groups_direct.responsibility_id%TYPE,

1344: AND ap.application_short_name = st.application_short_name;
1345:
1346: -- Cursor to check whether a particular responsibility is assigned to a person
1347: CURSOR c_get_assigned_resp (cp_user_id fnd_user_resp_groups_direct.user_id%TYPE,
1348: cp_responsibility_id fnd_user_resp_groups_direct.responsibility_id%TYPE,
1349: cp_resp_app_id fnd_user_resp_groups_direct.responsibility_application_id%TYPE) IS
1350: SELECT responsibility_id
1351: FROM fnd_user_resp_groups_direct
1352: WHERE user_id = cp_user_id

Line 1349: cp_resp_app_id fnd_user_resp_groups_direct.responsibility_application_id%TYPE) IS

1345:
1346: -- Cursor to check whether a particular responsibility is assigned to a person
1347: CURSOR c_get_assigned_resp (cp_user_id fnd_user_resp_groups_direct.user_id%TYPE,
1348: cp_responsibility_id fnd_user_resp_groups_direct.responsibility_id%TYPE,
1349: cp_resp_app_id fnd_user_resp_groups_direct.responsibility_application_id%TYPE) IS
1350: SELECT responsibility_id
1351: FROM fnd_user_resp_groups_direct
1352: WHERE user_id = cp_user_id
1353: AND responsibility_id = cp_responsibility_id

Line 1351: FROM fnd_user_resp_groups_direct

1347: CURSOR c_get_assigned_resp (cp_user_id fnd_user_resp_groups_direct.user_id%TYPE,
1348: cp_responsibility_id fnd_user_resp_groups_direct.responsibility_id%TYPE,
1349: cp_resp_app_id fnd_user_resp_groups_direct.responsibility_application_id%TYPE) IS
1350: SELECT responsibility_id
1351: FROM fnd_user_resp_groups_direct
1352: WHERE user_id = cp_user_id
1353: AND responsibility_id = cp_responsibility_id
1354: AND responsibility_application_id = cp_resp_app_id;
1355: