APPS.GHR_MRE_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 33: from per_org_structure_elements a,

29: child_fl VARCHAR2,
30: org_pos_fl VARCHAR2,
31: org_str_id NUMBER) is
32: SELECT a.organization_id_child org_pos_id
33: from per_org_structure_elements a,
34: per_org_structure_versions b
35: WHERE a.org_structure_version_id = b.org_structure_version_id
36: and a.org_structure_version_id = org_str_id
37: and child_fl = 'Y'

Line 42: from per_org_structure_elements

38: and org_pos_fl = 'O'
39: and a.org_structure_element_id in
40: (
41: SELECT org_structure_element_id
42: from per_org_structure_elements
43: start with organization_id_parent = cp_org_pos_id
44: connect by prior organization_id_child = organization_id_parent
45: )
46: union