APPS.PA_PROGRESS_UTILS dependencies on PA_TASK_TYPES

Line 932: FROM pa_proj_elements ppe, pa_task_types ptt

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

Line 1906: 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

1902: decode(ppe.object_type,'PA_TASKS',ptt.PROG_ENTRY_ENABLE_FLAG,'Y'),
1903: pppa.ALLOW_COLLAB_PROG_ENTRY,
1904: pppa.ALLOW_PHY_PRCNT_CMP_OVERRIDES,
1905: pppa.TASK_WEIGHT_BASIS_CODE
1906: 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
1907: WHERE ppe.project_id = p_project_id
1908: AND ppe.proj_element_id = p_object_id
1909: AND ppe.object_type = p_object_type
1910: AND ppe.type_id = ptt.task_type_id(+)

Line 2130: select 'X' from pa_task_types

2126: AND rownum <= 1;
2127:
2128: Cursor c_task_types
2129: is
2130: select 'X' from pa_task_types
2131: where ( initial_status_code = p_status_code
2132: or initial_progress_status_code = p_status_code)
2133: AND object_type = 'PA_TASKS' /* bug 3279978 FP M Enhancement */
2134: AND rownum <= 1;

Line 2175: -- Check referense in pa_task_types

2171: l_return_value := TRUE;
2172: end if;
2173: close c_proj_elem_ver_structure;
2174: end if;
2175: -- Check referense in pa_task_types
2176: if(NOT l_return_value) then
2177: open c_task_types;
2178: fetch c_task_types into l_dummy;
2179: if(c_task_types%FOUND) then

Line 2666: from pa_proj_elements ppe, pa_task_types ptt

2662: else
2663:
2664: select ptt.prog_entry_enable_flag
2665: into l_return_value
2666: from pa_proj_elements ppe, pa_task_types ptt
2667: where ppe.type_id = ptt.task_type_id(+)
2668: and ppe.project_id = p_project_id
2669: and ppe.proj_element_id = p_proj_element_id;
2670: end if;

Line 2787: pa_task_types ttype

2783: CURSOR c_get_del_associated_task IS
2784: SELECT 'x'
2785: FROM pa_proj_elements ppe,
2786: pa_object_relationships por,
2787: pa_task_types ttype
2788: WHERE
2789: ppe.object_type = 'PA_TASKS'
2790: and ppe.proj_element_id = por.object_id_from2
2791: and por.object_type_from = 'PA_TASKS'

Line 11788: , pa_task_types ttype

11784: SELECT decode(elem.base_percent_comp_deriv_code, null
11785: , ttype.base_percent_comp_deriv_code,'^'
11786: ,ttype.base_percent_comp_deriv_code,elem.base_percent_comp_deriv_code)
11787: FROM pa_proj_elements elem
11788: , pa_task_types ttype
11789: where elem.proj_element_id = c_task_id
11790: AND elem.project_id = c_project_id
11791: AND elem.object_type =c_object_type
11792: AND elem.type_id = ttype.task_type_id;