APPS.PA_PROGRESS_PVT dependencies on PA_TASK_TYPES

Line 603: pa_task_types ttype ,

599: pa_project_statuses pps1,
600: pa_project_statuses pps2,
601: pa_project_statuses pps3,
602: pa_project_statuses pps4,
603: pa_task_types ttype ,
604: pa_proj_rollup_temp temp
605: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
606: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
607: temp.object_id = pobj.object_id_from1

Line 840: pa_task_types ttype ,

836: pa_proj_element_versions ppev1,
837: pa_proj_element_versions ppev2,
838: pa_proj_elements ppe,
839: pa_project_statuses pps4,
840: pa_task_types ttype ,
841: pa_proj_rollup_temp temp
842: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
843: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
844: pobj.object_id_from1 = temp.object_id

Line 6499: , pa_task_types ttype

6495: CURSOR cur_base_p_comp_deriv_code(c_task_proj_elem_id NUMBER, c_project_id NUMBER)
6496: IS
6497: SELECT elem.status_code, stat.project_system_status_code, decode(elem.base_percent_comp_deriv_code, null, ttype.base_percent_comp_deriv_code,'^',ttype.base_percent_comp_deriv_code,elem.base_percent_comp_deriv_code), ttype.prog_entry_enable_flag
6498: FROM pa_proj_elements elem
6499: , pa_task_types ttype
6500: , pa_project_statuses stat
6501: where elem.proj_element_id = c_task_proj_elem_id
6502: AND elem.project_id = c_project_id
6503: AND elem.object_type ='PA_TASKS'