APPS.PER_PERSADIS_XMLP_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 140: PER_ORG_STRUCTURE_ELEMENTS POSE

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

Line 146: PER_ORG_STRUCTURE_ELEMENTS POSE1

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

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

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