APPS.PA_RELATIONSHIP_PVT dependencies on PA_STRUCTURE_TYPES

Line 93: pa_structure_types t

89:
90: CURSOR Is_Struc_Type_Valid(c_struc_type VARCHAR2, c_struc_id NUMBER) IS
91: select '1'
92: from pa_proj_structure_types s,
93: pa_structure_types t
94: where s.proj_element_id = c_struc_id
95: and s.structure_type_id = t.structure_type_id
96: and t.structure_type_class_code = c_struc_type;
97:

Line 123: pa_structure_types t,

119:
120: CURSOR Get_Latest_Pub_Ver(c_struc_type VARCHAR2, c_project_id NUMBER) IS
121: select pevs.element_version_id
122: from pa_proj_structure_types s,
123: pa_structure_types t,
124: pa_proj_elements pe,
125: pa_proj_elem_ver_structure pevs
126: where pe.object_type = 'PA_STRUCTURES'
127: and pe.project_id = c_project_id