APPS.GHR_BREAKDOWN_RPT dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 79: FROM per_org_structure_elements ORG

75: l_level NUMBER(3);
76: l_orgid hr_all_positions_f.organization_id%TYPE;
77: CURSOR c_level IS
78: SELECT DECODE(ORG.organization_id_child, l_orgid, LEVEL+1, LEVEL) ORG_LEVEL
79: FROM per_org_structure_elements ORG
80: WHERE (ORG.organization_id_child = l_orgid OR
81: ORG.organization_id_parent = l_orgid)
82: AND ORG.org_structure_version_id = l_org_strver_id
83: CONNECT

Line 90: FROM per_org_structure_elements);

86: AND PRIOR org_structure_version_id = org_structure_version_id
87: START
88: WITH organization_id_parent
89: NOT IN (SELECT organization_id_child
90: FROM per_org_structure_elements);
91: BEGIN
92: l_level := 0;
93: IF l_for_clause > 0 THEN
94: SELECT organization_id

Line 121: FROM per_org_structure_elements

117: SELECT LEVEL org_level,
118: organization_id_parent,
119: organization_id_child,
120: org_structure_version_id
121: FROM per_org_structure_elements
122: WHERE org_structure_version_id = l_org_strver_id
123: CONNECT
124: BY
125: PRIOR organization_id_parent = organization_id_child