DBA Data[Home] [Help]

APPS.PA_CONTROL_ITEMS_WORKFLOW dependencies on PA_PROJ_ELEM_VER_SCHEDULE

Line 2794: pa_proj_elem_ver_schedule pvsch,fnd_user fu, hz_parties hz

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
2798: and fu.person_party_id=hz.party_id