DBA Data[Home] [Help]

APPS.PA_PROGRESS_PUB dependencies on PA_STRUCTURE_TYPES

Line 8990: PA_Structure_types pst

8986: Select ppevs.element_version_id
8987: FROM PA_Proj_Elem_Ver_Structure ppevs,
8988: PA_Proj_Elements ppe,
8989: PA_Proj_Structure_Types ppst,
8990: PA_Structure_types pst
8991: WHERE ppevs.Project_ID = P_Project_ID
8992: AND ppevs.status_code = 'STRUCTURE_PUBLISHED'
8993: AND ppevs.proj_element_id = ppe.Proj_Element_ID
8994: AND ppe.Project_ID = ppevs.Project_ID

Line 21551: PA_Structure_types pst

21547: Select count(1)
21548: FROM PA_Proj_Elem_Ver_Structure ppevs,
21549: PA_Proj_Elements ppe,
21550: PA_Proj_Structure_Types ppst,
21551: PA_Structure_types pst
21552: WHERE ppevs.Project_ID = P_Project_ID
21553: AND ppevs.status_code = 'STRUCTURE_PUBLISHED'
21554: AND ppevs.proj_element_id = ppe.Proj_Element_ID
21555: AND ppe.Project_ID = ppevs.Project_ID