APPS.OKE_K_ACCESS_RULES_PKG2 dependencies on PA_PROJECT_ROLE_TYPES

Line 42: FROM pa_project_role_types

38: WHERE role_id = X_Role_ID;
39:
40: SELECT default_access_level
41: INTO L_def_access_level
42: FROM pa_project_role_types
43: WHERE project_role_id = X_Role_ID;
44:
45: --
46: -- Step 1

Line 425: SELECT menu_id FROM pa_project_role_types

421: FROM fnd_form_functions f
422: , ( SELECT function_id
423: FROM fnd_menu_entries
424: START WITH menu_id = (
425: SELECT menu_id FROM pa_project_role_types
426: WHERE project_role_id = X_Role_ID )
427: CONNECT BY menu_id = PRIOR sub_menu_id ) me
428: WHERE me.function_id = f.function_id;
429:

Line 589: FROM PA_Project_Role_Types PRT

585:
586: CURSOR c IS
587: SELECT PRT.Project_Role_ID Role_ID
588: , PRT.Meaning Role_Name
589: FROM PA_Project_Role_Types PRT
590: , PA_Role_Controls RC
591: WHERE RC.Project_Role_ID = PRT.Project_Role_ID
592: AND RC.Role_Control_Code = 'ALLOW_AS_CONTRACT_MEMBER'
593: AND PRT.Freeze_Rules_Flag = 'Y'