APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_PROJECT_ROLE_TYPES_VL

Line 2196: FROM pa_project_role_types_vl role

2192: AND res_temp.person_id IS NOT NULL;
2193:
2194: UPDATE pa_res_members_temp res_temp
2195: SET job_id = (SELECT default_job_id
2196: FROM pa_project_role_types_vl role
2197: WHERE role.project_role_id = res_temp.project_role_id
2198: AND ROWNUM = 1)
2199: WHERE res_temp.job_id IS NULL
2200: AND res_temp.project_role_id IS NOT NULL;

Line 3055: Pa_Project_Role_Types_vl

3051: Cursor c_PrjRoles (P_Prj_Role_Id IN Number) Is
3052: Select
3053: Meaning
3054: From
3055: Pa_Project_Role_Types_vl
3056: Where
3057: Project_Role_Id = P_Prj_Role_Id;
3058:
3059: Cursor c_Res_Attributes Is

Line 4120: Pa_Project_Role_Types_vl

4116: Cursor c_PrjRoles (P_Prj_Role_Id IN Number) Is
4117: Select
4118: Meaning
4119: From
4120: Pa_Project_Role_Types_vl
4121: Where
4122: Project_Role_Id = P_Prj_Role_Id;
4123:
4124: Begin

Line 4128: -- Get role from pa_project_role_types_vl

4124: Begin
4125:
4126: If P_Role_Id is Not Null Then
4127:
4128: -- Get role from pa_project_role_types_vl
4129: Open c_PrjRoles(P_Prj_Role_Id => P_Role_Id);
4130: Fetch c_PrjRoles Into l_Role_Displayed;
4131:
4132: If c_PrjRoles%NOTFOUND Then

Line 4308: Pa_Project_Role_Types_vl

4304: Cursor c_PrjRoles (P_Prj_Role_Id IN Number) Is
4305: Select
4306: Meaning
4307: From
4308: Pa_Project_Role_Types_vl
4309: Where
4310: Project_Role_Id = P_Prj_Role_Id;
4311:
4312: Cursor c_Res_Attributes