DBA Data[Home] [Help]

APPS.PA_XC_PROJECT_PUB dependencies on PA_OBJECT_RELATIONSHIPS

Line 149: FROM PA_OBJECT_RELATIONSHIPS por,

145:
146: CURSOR get_parent_id_csr (c_proj_element_id NUMBER)
147: IS
148: SELECT ppev2.proj_element_id
149: FROM PA_OBJECT_RELATIONSHIPS por,
150: PA_PROJ_ELEMENT_VERSIONS ppev,
151: PA_PROJ_ELEMENT_VERSIONS ppev2
152: WHERE por.relationship_type = 'S'
153: AND por.object_id_to1 = ppev.element_version_id