DBA Data[Home] [Help]

APPS.PA_PROGRESS_PVT dependencies on PA_TASK_TYPES

Line 605: pa_task_types ttype ,

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

Line 844: pa_task_types ttype ,

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

Line 6565: , pa_task_types ttype

6561: CURSOR cur_base_p_comp_deriv_code(c_task_proj_elem_id NUMBER, c_project_id NUMBER)
6562: IS
6563: 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
6564: FROM pa_proj_elements elem
6565: , pa_task_types ttype
6566: , pa_project_statuses stat
6567: where elem.proj_element_id = c_task_proj_elem_id
6568: AND elem.project_id = c_project_id
6569: AND elem.object_type ='PA_TASKS'

Line 11116: pa_task_types ttype ,

11112: pa_project_statuses pps1,
11113: pa_project_statuses pps2,
11114: pa_project_statuses pps3,
11115: pa_project_statuses pps4,
11116: pa_task_types ttype ,
11117: pa_proj_rollup_temp temp
11118: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
11119: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
11120: temp.object_id = pobj.object_id_from1

Line 11355: pa_task_types ttype ,

11351: pa_proj_element_versions ppev1,
11352: pa_proj_element_versions ppev2,
11353: pa_proj_elements ppe,
11354: pa_project_statuses pps4,
11355: pa_task_types ttype ,
11356: pa_proj_rollup_temp temp
11357: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
11358: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
11359: pobj.object_id_from1 = temp.object_id

Line 14676: pa_task_types ttype ,

14672: pa_project_statuses pps1,
14673: pa_project_statuses pps2,
14674: pa_project_statuses pps3,
14675: pa_project_statuses pps4,
14676: pa_task_types ttype ,
14677: pa_proj_rollup_temp temp
14678: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
14679: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
14680: temp.object_id = pobj.object_id_from1

Line 14915: pa_task_types ttype ,

14911: pa_proj_element_versions ppev1,
14912: pa_proj_element_versions ppev2,
14913: pa_proj_elements ppe,
14914: pa_project_statuses pps4,
14915: pa_task_types ttype ,
14916: pa_proj_rollup_temp temp
14917: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
14918: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
14919: pobj.object_id_from1 = temp.object_id