APPS.PA_PROGRESS_UTILS dependencies on PA_TASK_TYPES

Line 936: FROM pa_proj_elements ppe, pa_task_types ptt

932:
933: CURSOR cur_pa_task_prg2
934: IS
935: SELECT nvl(ppe.WQ_ACTUAL_ENTRY_CODE,ptt.ACTUAL_WQ_ENTRY_CODE)
936: FROM pa_proj_elements ppe, pa_task_types ptt
937: WHERE ppe.type_id = ptt.task_type_id(+)
938: AND ptt.object_type = 'PA_TASKS' /* bug 3279978 FP M Enhancement */
939: AND ppe.proj_element_id = p_task_id ;
940:

Line 1928: FROM pa_proj_elements ppe, pa_task_types ptt, pa_proj_progress_attr pppa, pa_proj_elem_ver_structure ppvs, pa_proj_structure_types ppst

1924: decode(ppe.object_type,'PA_TASKS',ptt.PROG_ENTRY_ENABLE_FLAG,'Y'),
1925: pppa.ALLOW_COLLAB_PROG_ENTRY,
1926: pppa.ALLOW_PHY_PRCNT_CMP_OVERRIDES,
1927: pppa.TASK_WEIGHT_BASIS_CODE
1928: FROM pa_proj_elements ppe, pa_task_types ptt, pa_proj_progress_attr pppa, pa_proj_elem_ver_structure ppvs, pa_proj_structure_types ppst
1929: WHERE ppe.project_id = p_project_id
1930: AND ppe.proj_element_id = p_object_id
1931: AND ppe.object_type = p_object_type
1932: AND ppe.type_id = ptt.task_type_id(+)

Line 2154: select 'X' from pa_task_types

2150: AND rownum <= 1;
2151:
2152: Cursor c_task_types
2153: is
2154: select 'X' from pa_task_types
2155: where ( initial_status_code = p_status_code
2156: or initial_progress_status_code = p_status_code)
2157: AND object_type = 'PA_TASKS' /* bug 3279978 FP M Enhancement */
2158: AND rownum <= 1;

Line 2199: -- Check referense in pa_task_types

2195: l_return_value := TRUE;
2196: end if;
2197: close c_proj_elem_ver_structure;
2198: end if;
2199: -- Check referense in pa_task_types
2200: if(NOT l_return_value) then
2201: open c_task_types;
2202: fetch c_task_types into l_dummy;
2203: if(c_task_types%FOUND) then

Line 2691: from pa_proj_elements ppe, pa_task_types ptt

2687: else
2688:
2689: select ptt.prog_entry_enable_flag
2690: into l_return_value
2691: from pa_proj_elements ppe, pa_task_types ptt
2692: where ppe.type_id = ptt.task_type_id(+)
2693: and ppe.project_id = p_project_id
2694: and ppe.proj_element_id = p_proj_element_id;
2695: end if;

Line 2812: pa_task_types ttype

2808: CURSOR c_get_del_associated_task IS
2809: SELECT 'x'
2810: FROM pa_proj_elements ppe,
2811: pa_object_relationships por,
2812: pa_task_types ttype
2813: WHERE
2814: ppe.object_type = 'PA_TASKS'
2815: and ppe.proj_element_id = por.object_id_from2
2816: and por.object_type_from = 'PA_TASKS'

Line 11868: , pa_task_types ttype

11864: SELECT decode(elem.base_percent_comp_deriv_code, null
11865: , ttype.base_percent_comp_deriv_code,'^'
11866: ,ttype.base_percent_comp_deriv_code,elem.base_percent_comp_deriv_code)
11867: FROM pa_proj_elements elem
11868: , pa_task_types ttype
11869: where elem.proj_element_id = c_task_id
11870: AND elem.project_id = c_project_id
11871: AND elem.object_type =c_object_type
11872: AND elem.type_id = ttype.task_type_id;