APPS.PA_DELIVERABLE_PROGRESS_PUB dependencies on PA_TASK_TYPES

Line 109: FROM pa_proj_elements elem, pa_task_types ptt

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

Line 119: FROM pa_proj_elements elem, pa_task_types ptt

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

Line 261: pa_task_types ttype

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