APPS.PA_TASK_APPROVAL_PKG dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 25: FROM PA_PROJ_ELEMENT_VERSIONS

21:
22: -- Cursor to identify if the given task has a parent task or not.
23: CURSOR C1 IS
24: SELECT 'Y'
25: FROM PA_PROJ_ELEMENT_VERSIONS
26: WHERE proj_element_id = p_proj_element
27: AND parent_structure_version_id = p_parent_struc_ver
28: AND financial_task_flag = 'Y'
29: AND EXISTS (SELECT 1

Line 86: FROM PA_PROJ_ELEMENT_VERSIONS

82:
83: -- Cursor to find out if p_parent_task_id is root/top task
84: CURSOR C2 IS
85: SELECT 'Y'
86: FROM PA_PROJ_ELEMENT_VERSIONS
87: WHERE proj_element_id = p_parent_task_id
88: AND parent_structure_version_id = p_parent_struc_ver
89: AND financial_task_flag = 'Y'
90: AND EXISTS (SELECT 1

Line 195: pa_proj_element_versions ppev,

191: budget_version_id in (
192: select budget_version_id from pa_budget_versions where ci_id = p_ci_id )
193: and exists (select 1
194: from pa_proj_elements ppe,
195: pa_proj_element_versions ppev,
196: pa_object_relationships por
197: where ppe.proj_element_id = pra.task_id
198: and ppe.project_id = pra.project_id
199: and ppe.link_task_flag = 'Y'