APPS.PA_PROGRESS_PUB dependencies on PA_TASK_TYPES

Line 5303: from pa_task_types ttype

5299: -- Bug 4282618 Begin
5300: CURSOR cur_prog_enabled(c_proj_element_id NUMBER)
5301: IS
5302: SELECT nvl(ttype.PROG_ENTRY_ENABLE_FLAG, 'N')
5303: from pa_task_types ttype
5304: , pa_proj_elements elem
5305: where elem.project_id = p_project_id
5306: and elem.proj_element_id = c_proj_element_id
5307: and elem.object_type = 'PA_TASKS'

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

6907: IS
6908:
6909: 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 )
6910: from pa_proj_elements ppe
6911: ,pa_task_types ptt --added during the bugfix 3962823.
6912: where ppe.project_id = p_project_id
6913: and ppe.proj_element_id = c_proj_element_id
6914: and ppe.type_id = ptt.task_type_id
6915: ;

Line 11287: , pa_task_types

11283:
11284: CURSOR c_get_progress_status(c_proj_element_id NUMBER) IS
11285: select initial_progress_status_code
11286: from pa_proj_elements
11287: , pa_task_types
11288: where project_id = p_project_id
11289: and proj_element_id = c_proj_element_id
11290: and type_id = task_type_id;
11291:

Line 11595: from pa_task_types ttype

11591: -- Bug 4282618 Begin
11592: CURSOR cur_prog_enabled(c_proj_element_id NUMBER)
11593: IS
11594: SELECT nvl(ttype.PROG_ENTRY_ENABLE_FLAG, 'N')
11595: from pa_task_types ttype
11596: , pa_proj_elements elem
11597: where elem.project_id = p_project_id
11598: and elem.proj_element_id = c_proj_element_id
11599: and elem.object_type = 'PA_TASKS'

Line 13724: pa_task_types ptt

13720: ppevs.scheduled_finish_date
13721: from pa_proj_elements ppe,
13722: pa_proj_element_versions ppev,
13723: pa_proj_elem_ver_schedule ppevs,
13724: pa_task_types ptt
13725: where ppev.proj_element_id = l_obj
13726: and ppev.parent_structure_version_id = l_latest_wp_struct_ver_id
13727: and ppev.proj_element_id = ppe.proj_element_id
13728: and ppevs.element_version_id = ppev.element_version_id

Line 13779: from pa_task_types ttype

13775:
13776: CURSOR cur_prog_setup(c_proj_element_id NUMBER, c_project_id number)
13777: IS
13778: SELECT nvl(ttype.PROG_ENTRY_ENABLE_FLAG, 'N'),initial_progress_status_code
13779: from pa_task_types ttype
13780: , pa_proj_elements elem
13781: where elem.project_id = c_project_id
13782: and elem.proj_element_id = c_proj_element_id
13783: and elem.object_type = 'PA_TASKS'