APPS.PER_PERSADIS_XMLP_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 143: PER_ORG_STRUCTURE_ELEMENTS POSE

139: POSE.ORGANIZATION_ID_PARENT
140: INTO
141: L_PARENT_ID
142: FROM
143: PER_ORG_STRUCTURE_ELEMENTS POSE
144: WHERE POSE.ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID
145: AND POSE.ORGANIZATION_ID_PARENT not in (
146: SELECT
147: POSE1.ORGANIZATION_ID_CHILD

Line 149: PER_ORG_STRUCTURE_ELEMENTS POSE1

145: AND POSE.ORGANIZATION_ID_PARENT not in (
146: SELECT
147: POSE1.ORGANIZATION_ID_CHILD
148: FROM
149: PER_ORG_STRUCTURE_ELEMENTS POSE1
150: WHERE POSE1.ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID );
151: EXCEPTION
152: WHEN OTHERS THEN
153: L_ERR := 1;

Line 158: || 'from per_org_structure_elements pose ' || 'connect by pose.organization_id_parent = '

154: END;
155: END IF;
156: IF L_ERR = 0 THEN
157: L_ORG_CONDITION := ' and org.organization_id in ' || '(select to_char(pose.organization_id_child) '
158: || 'from per_org_structure_elements pose ' || 'connect by pose.organization_id_parent = '
159: || 'prior pose.organization_id_child ' || 'and pose.org_structure_version_id = '
160: || TO_CHAR(P_ORG_STRUCTURE_VERSION_ID) || ' start with pose.organization_id_parent = '
161: || TO_CHAR(NVL(P_ORG_ID
162: ,L_PARENT_ID)) || ' and pose.org_structure_version_id = '