APPS.PA_PROJECT_DATES_PUB dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 69: PA_PROJ_ELEMENT_VERSIONS b

65: CURSOR get_task_sch_dates_csr(c_structure_version_id NUMBER, c_task_id NUMBER)
66: IS
67: SELECT a.scheduled_start_date, a.scheduled_finish_date
68: FROM PA_PROJ_ELEM_VER_SCHEDULE a,
69: PA_PROJ_ELEMENT_VERSIONS b
70: WHERE b.parent_structure_version_id = c_structure_version_id
71: AND b.project_id = p_project_id
72: AND b.proj_element_id = c_task_id
73: -- Bug Fix 4868867

Line 188: FROM pa_proj_element_versions a,

184: a.object_type,
185: a.wbs_level,
186: b.object_id_from1,
187: b.object_type_from
188: FROM pa_proj_element_versions a,
189: pa_object_relationships b
190: ,pa_proj_elements c --bug 4606475
191: WHERE a.parent_structure_version_id = c_structure_version_id
192: AND a.project_id = p_project_id

Line 209: FROM pa_proj_element_versions c

205: c.object_type,
206: 0,
207: to_number(NULL),
208: NULL
209: FROM pa_proj_element_versions c
210: WHERE c.element_version_id = c_structure_version_id;
211:
212: CURSOR get_buffer(c_structure_id NUMBER) IS
213: SELECT NVL(TXN_DATE_SYNC_BUF_DAYS,0)

Line 248: FROM pa_proj_element_versions ppev,

244: CURSOR cur_proj_elem_id( c_task_version_id NUMBER )
245: IS
246: SELECT ppev.proj_element_id,
247: ppe.element_number
248: FROM pa_proj_element_versions ppev,
249: pa_proj_elements ppe
250: WHERE ppev.element_version_id = c_task_version_id
251: AND ppev.proj_element_id = ppe.proj_element_id
252: AND ppe.link_task_flag = 'N' --bug 4606475