DBA Data[Home] [Help]

APPS.OKE_K_SECURITY_PKG dependencies on PA_PROJECT_ROLE_TYPES

Line 195: FROM pa_project_role_types prt

191:
192: CURSOR csr ( C_Role_ID NUMBER )
193: IS
194: SELECT default_access_level
195: FROM pa_project_role_types prt
196: WHERE prt.project_role_id = C_Role_ID;
197:
198: L_Access_Level VARCHAR2(30);
199: L_Role_ID NUMBER;

Line 505: , pa_project_role_types prt

501: CURSOR c1 IS
502: SELECT 'T'
503: FROM fnd_form_functions ff
504: , fnd_menu_entries me
505: , pa_project_role_types prt
506: WHERE prt.project_role_id = X_Role_ID
507: AND me.menu_id = prt.menu_id
508: AND me.grant_flag = 'Y'
509: AND ff.function_id = me.function_id