APPS.PA_ASSIGNMENTS_PUB dependencies on PA_PROJECT_TYPES_ALL

Line 918: l_admin_flag pa_project_types_all.administrative_flag%TYPE;

914: l_valid_flag VARCHAR2(1);
915: l_project_status_type PA_PROJECT_STATUSES.status_type%TYPE := null;
916: l_status_code PA_PROJECT_STATUSES.project_status_code%TYPE;
917: l_subteam_id pa_project_subteams.project_subteam_id%TYPE;
918: l_admin_flag pa_project_types_all.administrative_flag%TYPE;
919: l_unassigned_time pa_project_types_all.unassigned_time%TYPE;
920: l_object_type pa_project_subteams.object_type%TYPE;
921: l_object_id pa_project_subteams.object_id%TYPE;
922: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;

Line 919: l_unassigned_time pa_project_types_all.unassigned_time%TYPE;

915: l_project_status_type PA_PROJECT_STATUSES.status_type%TYPE := null;
916: l_status_code PA_PROJECT_STATUSES.project_status_code%TYPE;
917: l_subteam_id pa_project_subteams.project_subteam_id%TYPE;
918: l_admin_flag pa_project_types_all.administrative_flag%TYPE;
919: l_unassigned_time pa_project_types_all.unassigned_time%TYPE;
920: l_object_type pa_project_subteams.object_type%TYPE;
921: l_object_id pa_project_subteams.object_id%TYPE;
922: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;
923: l_role_list_id pa_role_lists.role_list_id%TYPE;

Line 942: FROM pa_projects_all ppa,pa_project_types_all ppt

938:
939: -- Start of Performance Fix 4898314 SQL ID 14905832
940: CURSOR get_project_number_info IS
941: SELECT ppt.administrative_flag, ppa.calendar_id, ppa.project_currency_code, ppt.unassigned_time
942: FROM pa_projects_all ppa,pa_project_types_all ppt
943: WHERE segment1 = p_project_number
944: AND PPA.PROJECT_TYPE = PPT.PROJECT_TYPE
945: AND PPA.ORG_ID = PPT.ORG_ID;
946: -- End of Performance Fix 4898314 SQL ID 14905832