DBA Data[Home] [Help]

APPS.GMD_API_GRP dependencies on GMD_SECURITY_PROFILES

Line 1024: FROM gmd_security_profiles sp

1020: CURSOR Cur_check_orgn_access (V_default_user_id PLS_INTEGER) IS
1021: SELECT 1
1022: FROM sys.dual
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

Line 1056: FROM gmd_security_profiles sp

1052:
1053:
1054: CURSOR Cur_check_formula_access (V_default_user_id PLS_INTEGER) IS
1055: SELECT sp.access_type_ind
1056: FROM gmd_security_profiles sp
1057: WHERE sp.assign_method_ind = 'A'
1058: AND ( ( sp.user_id = V_default_user_id
1059: OR sp.user_id = fnd_global.user_id
1060: )