APPS.PA_WORKPLAN_WORKFLOW dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 105: pa_proj_element_versions b

101:
102: cursor get_working_ver(c_structure_version_id NUMBER) IS
103: select a.element_version_id
104: from pa_proj_elem_ver_structure a,
105: pa_proj_element_versions b
106: where b.project_id = a.project_id
107: and b.proj_element_id = a.proj_element_id
108: and a.status_code = 'STRUCTURE_WORKING'
109: and b.element_version_id = c_structure_version_id;

Line 933: FROM pa_proj_element_versions pev ,

929:
930: CURSOR get_struct_version_id
931: IS
932: SELECT pev.element_version_id
933: FROM pa_proj_element_versions pev ,
934: pa_proj_structure_types pst
935: WHERE pev.project_id = l_project_id
936: AND pev.object_type = 'PA_STRUCTURES'
937: AND pev.proj_element_id = pst.proj_element_id

Line 952: pa_proj_element_versions pev,

948: ,ppe.wf_process
949: ,ppe.wf_start_lead_days
950: ,element_number
951: FROM pa_proj_elem_ver_schedule pevs ,
952: pa_proj_element_versions pev,
953: pa_proj_elements ppe
954: WHERE pev.parent_structure_version_id = c_parent_struct_ver_id
955: AND pev.object_type = 'PA_TASKS'
956: AND ppe.object_type = 'PA_TASKS'