APPS.PA_WORKPLAN_WORKFLOW_CLIENT dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 77: pa_proj_element_versions b

73: CURSOR getStructureVerInfo IS
74: select a.VERSION_NUMBER, a.NAME, a.PROJECT_ID, a.LOCKED_BY_PERSON_ID,
75: a.record_version_number, a.description
76: from pa_proj_elem_ver_structure a,
77: pa_proj_element_versions b
78: where p_structure_version_id = b.element_version_id
79: and b.project_id = a.project_id
80: and b.element_version_id = a.element_version_id;
81:

Line 548: , pa_proj_element_versions ver

544: --and object_id = l_project_id Bug 4562762
545: -- Bug 4562762 : Added logic to select program too
546: and object_id IN (select ver.project_id
547: from pa_object_relationships obj
548: , pa_proj_element_versions ver
549: where obj.object_id_to1=l_structure_version_id
550: and obj.relationship_type = 'LW'
551: and obj.object_id_from1=ver.element_version_id
552: union