APPS.PA_DELIVERABLE_PROGRESS_PUB dependencies on PA_TASK_TYPES

Line 110: FROM pa_proj_elements elem, pa_task_types ptt

106:
107: CURSOR cur_get_del_type_prog_attr
108: IS
109: SELECT nvl(ptt.PROG_ENTRY_ENABLE_FLAG, 'N'), elem.type_id, elem.status_code, elem.NAME -- Bug 6497559
110: FROM pa_proj_elements elem, pa_task_types ptt
111: WHERE project_id = p_project_id
112: AND proj_element_id = p_object_id
113: AND elem.object_type ='PA_DELIVERABLES'
114: AND elem.type_id = ptt.task_type_id(+)

Line 120: FROM pa_proj_elements elem, pa_task_types ptt

116:
117: CURSOR cur_get_task_type_prog_attr
118: IS
119: SELECT nvl(ptt.PROG_ENTRY_ENABLE_FLAG, 'N')
120: FROM pa_proj_elements elem, pa_task_types ptt
121: WHERE project_id = p_project_id
122: AND proj_element_id = p_task_id
123: AND elem.object_type ='PA_TASKS'
124: AND elem.type_id = ptt.task_type_id(+)

Line 262: pa_task_types ttype

258: SELECT ppe.proj_element_id
259: into temp_task_id
260: FROM pa_proj_elements ppe,
261: pa_object_relationships por,
262: pa_task_types ttype
263: WHERE
264: ppe.object_type = 'PA_TASKS'
265: and por.object_id_to2 = p_object_id
266: and ppe.proj_element_id = por.object_id_from2