APPS.GMD_API_GRP dependencies on FND_USER_RESP_GROUPS

Line 1031: FROM FND_USER_RESP_GROUPS rg

1027: FROM gmd_security_profiles sp
1028: WHERE sp.access_type_ind = 'U'
1029: AND nvl(responsibility_id, fnd_global.resp_id) = fnd_global.resp_id /* Bug No.9077438 */
1030: AND ( responsibility_id IN ( SELECT rg.responsibility_id
1031: FROM FND_USER_RESP_GROUPS rg
1032: WHERE rg.user_id = fnd_global.user_id
1033: AND SYSDATE BETWEEN rg.start_date
1034: AND NVL(rg.end_date, SYSDATE)
1035: )

Line 1067: FROM FND_USER_RESP_GROUPS rg

1063: AND ( ( sp.user_id = V_default_user_id
1064: OR sp.user_id = fnd_global.user_id
1065: )
1066: OR ( EXISTS ( SELECT rg.responsibility_id
1067: FROM FND_USER_RESP_GROUPS rg
1068: WHERE rg.user_id = fnd_global.user_id
1069: AND sp.responsibility_id = rg.responsibility_id
1070: AND SYSDATE BETWEEN rg.start_date AND NVL(rg.end_date, SYSDATE)
1071: )

Line 1104: FROM FND_USER_RESP_GROUPS rg

1100: WHERE ( ( fs.user_id = V_default_user_id
1101: OR fs.user_id = fnd_global.user_id
1102: )
1103: OR ( EXISTS ( SELECT rg.responsibility_id
1104: FROM FND_USER_RESP_GROUPS rg
1105: WHERE rg.user_id = fnd_global.user_id
1106: AND fs.responsibility_id = rg.responsibility_id
1107: AND SYSDATE BETWEEN rg.start_date
1108: AND NVL(rg.end_date, SYSDATE)