DBA Data[Home] [Help]

APPS.GMD_API_GRP dependencies on GMD_SECURITY_PROFILES

Line 1027: FROM gmd_security_profiles sp

1023: CURSOR Cur_check_orgn_access (V_default_user_id PLS_INTEGER) IS
1024: SELECT 1
1025: FROM sys.dual
1026: WHERE EXISTS ( SELECT 1
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

Line 1060: FROM gmd_security_profiles sp

1056:
1057:
1058: CURSOR Cur_check_formula_access (V_default_user_id PLS_INTEGER) IS
1059: SELECT sp.access_type_ind
1060: FROM gmd_security_profiles sp
1061: WHERE sp.assign_method_ind = 'A'
1062: AND NVL(responsibility_id, fnd_global.resp_id) = fnd_global.resp_id /* Bug No.9077438 */
1063: AND ( ( sp.user_id = V_default_user_id
1064: OR sp.user_id = fnd_global.user_id