APPS.PA_FIN_PLAN_UTILS dependencies on PA_PROJ_ELEMENTS

Line 10523: from pa_proj_elements ppe,

10519: l_task_id NUMBER;
10520:
10521: CURSOR get_wp_id IS
10522: SELECT ppe.proj_element_id
10523: from pa_proj_elements ppe,
10524: pa_proj_structure_types ppst,
10525: pa_structure_types pst
10526: where ppe.project_id = p_project_id
10527: and ppe.proj_element_id = ppst.proj_element_id

Line 10531: CURSOR get_tasks (c_structure_id pa_proj_elements.proj_element_id%TYPE) IS

10527: and ppe.proj_element_id = ppst.proj_element_id
10528: and ppst.structure_type_id = pst.structure_type_id
10529: and pst.structure_type_class_code = 'WORKPLAN';
10530:
10531: CURSOR get_tasks (c_structure_id pa_proj_elements.proj_element_id%TYPE) IS
10532: SELECT ppev1.proj_element_id
10533: FROM pa_proj_element_versions ppev1,
10534: pa_proj_element_versions ppev2
10535: WHERE ppev2.object_type = 'PA_STRUCTURES'

Line 10542: from pa_proj_elements

10538: AND ppev1.parent_structure_version_id = ppev2.element_version_id
10539: AND ppev1.object_type = 'PA_TASKS';
10540: /*** Bug 3683382 modified the query for performance
10541: SELECT proj_element_id
10542: from pa_proj_elements
10543: where project_id = p_project_id
10544: and object_type = 'PA_TASKS'
10545: and proj_element_id IN (
10546: select ppev1.proj_element_id