APPS.PER_PERSACTR_XMLP_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 163: PER_ORG_STRUCTURE_ELEMENTS POSE

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

Line 169: PER_ORG_STRUCTURE_ELEMENTS POSE1

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

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

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