APPS.PA_TASK_WORKFLOW_PKG dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 1136: PA_PROJ_ELEMENT_VERSIONS ppev

1132: SELECT ppe.proj_element_id,
1133: ppev.element_version_id,
1134: ppev.parent_structure_version_id
1135: FROM PA_PROJ_ELEMENTS ppe,
1136: PA_PROJ_ELEMENT_VERSIONS ppev
1137: WHERE ppev.proj_element_id = ppe.proj_element_id
1138: AND ppe.proj_element_id = p_proj_elemt_id;
1139:
1140: -- Cursor to find out all the immediate child tasks of a task which are in

Line 1147: FROM PA_PROJ_ELEMENTS PPE, PA_OBJECT_RELATIONSHIPS POR, PA_PROJ_ELEMENT_VERSIONS PPEV

1143: SELECT ppe.proj_element_Id task_id,
1144: ppe.record_version_number,
1145: ppev.parent_structure_version_id,
1146: ppe.task_approver_id task_app_chg_id
1147: FROM PA_PROJ_ELEMENTS PPE, PA_OBJECT_RELATIONSHIPS POR, PA_PROJ_ELEMENT_VERSIONS PPEV
1148: WHERE ppe.project_id = p_project_id
1149: AND ppev.proj_element_id = ppe.proj_element_id
1150: AND ppev.financial_task_flag = 'Y'
1151: AND por.object_id_to1 = ppev.element_version_id

Line 1440: PA_PROJ_ELEMENT_VERSIONS ppev

1436: SELECT ppe.proj_element_id,
1437: ppev.element_version_id,
1438: ppev.parent_structure_version_id
1439: FROM PA_PROJ_ELEMENTS ppe,
1440: PA_PROJ_ELEMENT_VERSIONS ppev
1441: WHERE ppev.proj_element_id = ppe.proj_element_id
1442: AND ppe.proj_element_id = p_proj_elemt_id;
1443:
1444: -- Cursor to fetch the TASK provided along with all of it's child tasks which are

Line 1452: PA_PROJ_ELEMENT_VERSIONS PPEV

1448: ppe.record_version_number,
1449: ppev.parent_structure_version_id,
1450: ppev.element_version_id
1451: FROM PA_PROJ_ELEMENTS PPE,
1452: PA_PROJ_ELEMENT_VERSIONS PPEV
1453: WHERE ppe.project_id = p_project_id
1454: AND ppev.proj_element_id = ppe.proj_element_id
1455: AND ppev.financial_task_flag = 'Y'
1456: AND ppe.task_status IN ('NEW','SUBMITTED','PENDING')

Line 1472: PA_PROJ_ELEMENT_VERSIONS PPEV

1468: ppe.record_version_number,
1469: ppev.parent_structure_version_id,
1470: ppev.element_version_id
1471: FROM PA_PROJ_ELEMENTS PPE,
1472: PA_PROJ_ELEMENT_VERSIONS PPEV
1473: WHERE ppe.project_id = p_project_id
1474: AND ppe.proj_element_id = ppev.proj_element_id
1475: AND ppe.proj_element_id =p_task_id;
1476:

Line 1566: pa_proj_element_versions ppev,

1562: budget_version_id in (
1563: select budget_version_id from pa_budget_versions where ci_id = l_ci_id )
1564: and exists (select 1
1565: from pa_proj_elements ppe,
1566: pa_proj_element_versions ppev,
1567: pa_object_relationships por
1568: where ppe.proj_element_id = pra.task_id
1569: and ppe.project_id = pra.project_id
1570: and ppe.link_task_flag = 'Y'