APPS.PA_PROJECT_DATES_PUB dependencies on PA_PROJ_ELEMENTS

Line 110: FROM PA_PROJ_ELEMENTS

106:
107: CURSOR get_task_bas_dates_csr(c_task_id NUMBER)
108: IS
109: SELECT baseline_start_date, baseline_finish_date
110: FROM PA_PROJ_ELEMENTS
111: WHERE proj_element_id = c_task_id;
112:
113: CURSOR get_proj_sch_dates_csr
114: IS

Line 154: FROM pa_proj_elements a,

150:
151: CURSOR get_structure
152: IS
153: SELECT a.proj_element_id
154: FROM pa_proj_elements a,
155: pa_proj_structure_types b,
156: pa_structure_types c
157: WHERE a.proj_element_id = b.proj_element_id
158: AND a.object_type = 'PA_STRUCTURES'

Line 190: ,pa_proj_elements c --bug 4606475

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
193: AND a.element_version_id = b.object_id_to1
194: AND b.object_type_to = 'PA_TASKS'

Line 249: pa_proj_elements ppe

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
253: ;

Line 373: -- If PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(l_element_version_id) <> 'Y' then

369: l_task_finish_date := l_task_finish_date + l_buffer;
370:
371: -- Start of addition for bug 5338208
372: -- changed IS_LOWEST_TASK() to IS_LOWEST_PROJ_TASK for bug 5698103
373: -- If PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(l_element_version_id) <> 'Y' then
374: If PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_PROJ_TASK(l_element_version_id, p_project_id) <> 'Y' then
375: l_task_start_date := Null;
376: l_task_finish_date:= Null;
377: END if;

Line 374: If PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_PROJ_TASK(l_element_version_id, p_project_id) <> 'Y' then

370:
371: -- Start of addition for bug 5338208
372: -- changed IS_LOWEST_TASK() to IS_LOWEST_PROJ_TASK for bug 5698103
373: -- If PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(l_element_version_id) <> 'Y' then
374: If PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_PROJ_TASK(l_element_version_id, p_project_id) <> 'Y' then
375: l_task_start_date := Null;
376: l_task_finish_date:= Null;
377: END if;
378: -- End of addition for bug 5338208

Line 552: IF ('Y' = PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_proj_element_id2)) THEN

548: CLOSE cur_proj_elem_id;
549: --bug 2831656
550:
551: --bug 3974958
552: IF ('Y' = PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_proj_element_id2)) THEN
553: --end bug 3974958
554: /* Start of changes for bug 5665772 */
555:
556: SELECT pt.parent_task_id,