APPS.PA_CONTROL_ITEMS_WORKFLOW dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 2793: from pa_proj_elements ppe,pa_proj_element_versions ppev,

2789: CURSOR c_ci_task_info IS
2790: select ppe.element_number task_number,ppe.name task_name,ppe.description description,
2791: pvsch.scheduled_start_date start_date,pvsch.scheduled_finish_date finish_date,
2792: hz.party_name approver_name
2793: from pa_proj_elements ppe,pa_proj_element_versions ppev,
2794: pa_proj_elem_ver_schedule pvsch,fnd_user fu, hz_parties hz
2795: where ppe.proj_element_id = ppev.proj_element_id
2796: and pvsch.element_version_id = ppev.element_version_id
2797: and ppe.task_approver_id=fu.user_id

Line 2807: pa_proj_element_versions ppev,

2803: budget_version_id in (
2804: select budget_version_id from pa_budget_versions where ci_id =document_id)
2805: and exists (select 1
2806: from pa_proj_elements ppe,
2807: pa_proj_element_versions ppev,
2808: pa_object_relationships por
2809: where ppe.proj_element_id = pra.task_id
2810: and ppe.project_id = pra.project_id
2811: and ppe.link_task_flag = 'Y'