DBA Data[Home] [Help]

APPS.PA_WORKPLAN_WORKFLOW_CLIENT dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 74: pa_proj_element_versions b

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

Line 530: , pa_proj_element_versions ver

526: --and object_id = l_project_id Bug 4562762
527: -- Bug 4562762 : Added logic to select program too
528: and object_id IN (select ver.project_id
529: from pa_object_relationships obj
530: , pa_proj_element_versions ver
531: where obj.object_id_to1=l_structure_version_id
532: and obj.relationship_type = 'LW'
533: and obj.object_id_from1=ver.element_version_id
534: union