APPS.GMD_API_GRP dependencies on FND_USER_RESP_GROUPS

Line 1027: FROM FND_USER_RESP_GROUPS rg

1023: WHERE EXISTS ( SELECT 1
1024: FROM gmd_security_profiles sp
1025: WHERE sp.access_type_ind = 'U'
1026: AND ( responsibility_id IN ( SELECT rg.responsibility_id
1027: FROM FND_USER_RESP_GROUPS rg
1028: WHERE rg.user_id = fnd_global.user_id
1029: AND SYSDATE BETWEEN rg.start_date
1030: AND NVL(rg.end_date, SYSDATE)
1031: )

Line 1062: FROM FND_USER_RESP_GROUPS rg

1058: AND ( ( sp.user_id = V_default_user_id
1059: OR sp.user_id = fnd_global.user_id
1060: )
1061: OR ( EXISTS ( SELECT rg.responsibility_id
1062: FROM FND_USER_RESP_GROUPS rg
1063: WHERE rg.user_id = fnd_global.user_id
1064: AND sp.responsibility_id = rg.responsibility_id
1065: AND SYSDATE BETWEEN rg.start_date AND NVL(rg.end_date, SYSDATE)
1066: )

Line 1099: FROM FND_USER_RESP_GROUPS rg

1095: WHERE ( ( fs.user_id = V_default_user_id
1096: OR fs.user_id = fnd_global.user_id
1097: )
1098: OR ( EXISTS ( SELECT rg.responsibility_id
1099: FROM FND_USER_RESP_GROUPS rg
1100: WHERE rg.user_id = fnd_global.user_id
1101: AND fs.responsibility_id = rg.responsibility_id
1102: AND SYSDATE BETWEEN rg.start_date
1103: AND NVL(rg.end_date, SYSDATE)