APPS.PER_PERSACTR_XMLP_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 161: PER_ORG_STRUCTURE_ELEMENTS POSE

157: POSE.ORGANIZATION_ID_PARENT
158: INTO
159: L_PARENT_ID
160: FROM
161: PER_ORG_STRUCTURE_ELEMENTS POSE
162: WHERE POSE.ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID
163: AND POSE.ORGANIZATION_ID_PARENT not in (
164: SELECT
165: POSE1.ORGANIZATION_ID_CHILD

Line 167: PER_ORG_STRUCTURE_ELEMENTS POSE1

163: AND POSE.ORGANIZATION_ID_PARENT not in (
164: SELECT
165: POSE1.ORGANIZATION_ID_CHILD
166: FROM
167: PER_ORG_STRUCTURE_ELEMENTS POSE1
168: WHERE POSE1.ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID );
169: EXCEPTION
170: WHEN OTHERS THEN
171: L_ERR := 1;

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

172: END;
173: END IF;
174: IF L_ERR = 0 THEN
175: L_ORG_CONDITION := ' and org.organization_id in ' || '(select to_char(pose.organization_id_child) '
176: || 'from per_org_structure_elements pose ' || 'connect by pose.organization_id_parent = '
177: || 'prior pose.organization_id_child ' || 'and pose.org_structure_version_id = '
178: || TO_CHAR(P_ORG_STRUCTURE_VERSION_ID) || ' start with pose.organization_id_parent = '
179: || TO_CHAR(NVL(P_ORG_ID
180: ,L_PARENT_ID)) || ' and pose.org_structure_version_id = '