DBA Data[Home] [Help]

APPS.PA_PROGRESS_PUB dependencies on PA_STRUCTURE_TYPES

Line 8572: PA_Structure_types pst

8568: Select ppevs.element_version_id
8569: FROM PA_Proj_Elem_Ver_Structure ppevs,
8570: PA_Proj_Elements ppe,
8571: PA_Proj_Structure_Types ppst,
8572: PA_Structure_types pst
8573: WHERE ppevs.Project_ID = P_Project_ID
8574: AND ppevs.status_code = 'STRUCTURE_PUBLISHED'
8575: AND ppevs.proj_element_id = ppe.Proj_Element_ID
8576: AND ppe.Project_ID = ppevs.Project_ID

Line 20088: PA_Structure_types pst

20084: Select count(1)
20085: FROM PA_Proj_Elem_Ver_Structure ppevs,
20086: PA_Proj_Elements ppe,
20087: PA_Proj_Structure_Types ppst,
20088: PA_Structure_types pst
20089: WHERE ppevs.Project_ID = P_Project_ID
20090: AND ppevs.status_code = 'STRUCTURE_PUBLISHED'
20091: AND ppevs.proj_element_id = ppe.Proj_Element_ID
20092: AND ppe.Project_ID = ppevs.Project_ID