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