DBA Data[Home] [Help]

APPS.PA_WORKPLAN_WORKFLOW_CLIENT dependencies on PA_OBJECT_RELATIONSHIPS

Line 547: from pa_object_relationships obj

543: where object_type = 'PA_PROJECTS'
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