DBA Data[Home] [Help]

APPS.GHR_MTO_PKG dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 180: from per_pos_structure_elements a,

176: where b.organization_id = nvl(cp_orgid, b.organization_id)
177: and org_pos_fl = 'O'
178: union
179: select a.subordinate_position_id org_pos_id
180: from per_pos_structure_elements a,
181: per_pos_structure_versions b
182: where a.pos_structure_version_id = b.pos_structure_version_id
183: and a.pos_structure_version_id = org_str_id
184: and child_fl = 'Y'

Line 189: from per_pos_structure_elements

185: and org_pos_fl = 'P'
186: and a.pos_structure_element_id in
187: (
188: select pos_structure_element_id
189: from per_pos_structure_elements
190: start with parent_position_id = cp_orgid
191: connect by prior subordinate_position_id = parent_position_id
192: )
193: union