APPS.PA_ASSIGNMENTS_PUB dependencies on PA_PROJECT_TYPES_ALL

Line 953: l_admin_flag pa_project_types_all.administrative_flag%TYPE;

949: l_valid_flag VARCHAR2(1);
950: l_project_status_type PA_PROJECT_STATUSES.status_type%TYPE := null;
951: l_status_code PA_PROJECT_STATUSES.project_status_code%TYPE;
952: l_subteam_id pa_project_subteams.project_subteam_id%TYPE;
953: l_admin_flag pa_project_types_all.administrative_flag%TYPE;
954: l_unassigned_time pa_project_types_all.unassigned_time%TYPE;
955: l_object_type pa_project_subteams.object_type%TYPE;
956: l_object_id pa_project_subteams.object_id%TYPE;
957: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;

Line 954: l_unassigned_time pa_project_types_all.unassigned_time%TYPE;

950: l_project_status_type PA_PROJECT_STATUSES.status_type%TYPE := null;
951: l_status_code PA_PROJECT_STATUSES.project_status_code%TYPE;
952: l_subteam_id pa_project_subteams.project_subteam_id%TYPE;
953: l_admin_flag pa_project_types_all.administrative_flag%TYPE;
954: l_unassigned_time pa_project_types_all.unassigned_time%TYPE;
955: l_object_type pa_project_subteams.object_type%TYPE;
956: l_object_id pa_project_subteams.object_id%TYPE;
957: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;
958: l_role_list_id pa_role_lists.role_list_id%TYPE;

Line 977: FROM pa_projects_all ppa,pa_project_types_all ppt

973:
974: -- Start of Performance Fix 4898314 SQL ID 14905832
975: CURSOR get_project_number_info IS
976: SELECT ppt.administrative_flag, ppa.calendar_id, ppa.project_currency_code, ppt.unassigned_time
977: FROM pa_projects_all ppa,pa_project_types_all ppt
978: WHERE segment1 = p_project_number
979: AND PPA.PROJECT_TYPE = PPT.PROJECT_TYPE
980: AND PPA.ORG_ID = PPT.ORG_ID;
981: -- End of Performance Fix 4898314 SQL ID 14905832