APPS.PA_PROGRESS_PUB dependencies on PA_TASK_TYPES

Line 3997: from pa_task_types

3993: where proj_element_id = p_object_id;
3994:
3995: cursor chk_task_type_ppc_enabled (p_task_type_id number)is
3996: select percent_comp_enable_flag
3997: from pa_task_types
3998: where task_type_id = p_task_type_id ;
3999:
4000: cursor chk_structure_ppc_enabled is
4001: select percent_comp_enable_flag

Line 5707: from pa_task_types ttype

5703: -- Bug 4282618 Begin
5704: CURSOR cur_prog_enabled(c_proj_element_id NUMBER)
5705: IS
5706: SELECT nvl(ttype.PROG_ENTRY_ENABLE_FLAG, 'N')
5707: from pa_task_types ttype
5708: , pa_proj_elements elem
5709: where elem.project_id = p_project_id
5710: and elem.proj_element_id = c_proj_element_id
5711: and elem.object_type = 'PA_TASKS'

Line 7317: ,pa_task_types ptt --added during the bugfix 3962823.

7313: IS
7314:
7315: SELECT decode( ppe.base_percent_comp_deriv_code, null, ptt.base_percent_comp_deriv_code, '^', ptt.base_percent_comp_deriv_code, ppe.base_percent_comp_deriv_code )
7316: from pa_proj_elements ppe
7317: ,pa_task_types ptt --added during the bugfix 3962823.
7318: where ppe.project_id = p_project_id
7319: and ppe.proj_element_id = c_proj_element_id
7320: and ppe.type_id = ptt.task_type_id
7321: ;

Line 11733: , pa_task_types

11729:
11730: CURSOR c_get_progress_status(c_proj_element_id NUMBER) IS
11731: select initial_progress_status_code
11732: from pa_proj_elements
11733: , pa_task_types
11734: where project_id = p_project_id
11735: and proj_element_id = c_proj_element_id
11736: and type_id = task_type_id;
11737:

Line 12048: from pa_task_types ttype

12044: -- Bug 4282618 Begin
12045: CURSOR cur_prog_enabled(c_proj_element_id NUMBER)
12046: IS
12047: SELECT nvl(ttype.PROG_ENTRY_ENABLE_FLAG, 'N')
12048: from pa_task_types ttype
12049: , pa_proj_elements elem
12050: where elem.project_id = p_project_id
12051: and elem.proj_element_id = c_proj_element_id
12052: and elem.object_type = 'PA_TASKS'

Line 14217: pa_task_types ptt

14213: ppevs.scheduled_finish_date
14214: from pa_proj_elements ppe,
14215: pa_proj_element_versions ppev,
14216: pa_proj_elem_ver_schedule ppevs,
14217: pa_task_types ptt
14218: where ppev.proj_element_id = l_obj
14219: and ppev.parent_structure_version_id = l_latest_wp_struct_ver_id
14220: and ppev.proj_element_id = ppe.proj_element_id
14221: and ppevs.element_version_id = ppev.element_version_id

Line 14272: from pa_task_types ttype

14268:
14269: CURSOR cur_prog_setup(c_proj_element_id NUMBER, c_project_id number)
14270: IS
14271: SELECT nvl(ttype.PROG_ENTRY_ENABLE_FLAG, 'N'),initial_progress_status_code
14272: from pa_task_types ttype
14273: , pa_proj_elements elem
14274: where elem.project_id = c_project_id
14275: and elem.proj_element_id = c_proj_element_id
14276: and elem.object_type = 'PA_TASKS'