APPS.PA_RELATIONSHIP_PVT dependencies on PA_PROJ_STRUCTURE_TYPES

Line 92: from pa_proj_structure_types s,

88: l_msg_index_out NUMBER;
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;

Line 122: from pa_proj_structure_types s,

118: and rel.object_id_to1 = pev.element_version_id;
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'