DBA Data[Home] [Help]

APPS.GHR_MTO_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 156: from per_org_structure_elements a,

152: child_fl varchar2,
153: org_pos_fl varchar2,
154: org_str_id number) is
155: select a.organization_id_child org_pos_id
156: from per_org_structure_elements a,
157: per_org_structure_versions b
158: where a.org_structure_version_id = b.org_structure_version_id
159: and a.org_structure_version_id = org_str_id
160: and child_fl = 'Y'

Line 165: from per_org_structure_elements

161: and org_pos_fl = 'O'
162: and a.org_structure_element_id in
163: (
164: select org_structure_element_id
165: from per_org_structure_elements
166: -- VSM added nvl( .. to the start... clause
167: -- enhancement in selection criteria as org_id can be be null [Masscrit.doc]
168: start with organization_id_parent = cp_orgid
169: connect by prior organization_id_child = organization_id_parent