APPS.PA_FIN_PLAN_UTILS dependencies on PA_PROJ_ELEMENTS

Line 10517: from pa_proj_elements ppe,

10513: l_task_id NUMBER;
10514:
10515: CURSOR get_wp_id IS
10516: SELECT ppe.proj_element_id
10517: from pa_proj_elements ppe,
10518: pa_proj_structure_types ppst,
10519: pa_structure_types pst
10520: where ppe.project_id = p_project_id
10521: and ppe.proj_element_id = ppst.proj_element_id

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

10521: and ppe.proj_element_id = ppst.proj_element_id
10522: and ppst.structure_type_id = pst.structure_type_id
10523: and pst.structure_type_class_code = 'WORKPLAN';
10524:
10525: CURSOR get_tasks (c_structure_id pa_proj_elements.proj_element_id%TYPE) IS
10526: SELECT ppev1.proj_element_id
10527: FROM pa_proj_element_versions ppev1,
10528: pa_proj_element_versions ppev2
10529: WHERE ppev2.object_type = 'PA_STRUCTURES'

Line 10536: from pa_proj_elements

10532: AND ppev1.parent_structure_version_id = ppev2.element_version_id
10533: AND ppev1.object_type = 'PA_TASKS';
10534: /*** Bug 3683382 modified the query for performance
10535: SELECT proj_element_id
10536: from pa_proj_elements
10537: where project_id = p_project_id
10538: and object_type = 'PA_TASKS'
10539: and proj_element_id IN (
10540: select ppev1.proj_element_id