APPS.PER_PERSAIPE_XMLP_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 131: PER_ORG_STRUCTURE_ELEMENTS POSE

127: POSE.ORGANIZATION_ID_PARENT
128: INTO
129: L_PARENT_ID
130: FROM
131: PER_ORG_STRUCTURE_ELEMENTS POSE
132: WHERE POSE.ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID
133: AND POSE.ORGANIZATION_ID_PARENT not in (
134: SELECT
135: POSE1.ORGANIZATION_ID_CHILD

Line 137: PER_ORG_STRUCTURE_ELEMENTS POSE1

133: AND POSE.ORGANIZATION_ID_PARENT not in (
134: SELECT
135: POSE1.ORGANIZATION_ID_CHILD
136: FROM
137: PER_ORG_STRUCTURE_ELEMENTS POSE1
138: WHERE POSE1.ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID );
139: EXCEPTION
140: WHEN OTHERS THEN
141: L_ERR := 1;

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

142: END;
143: END IF;
144: IF L_ERR = 0 THEN
145: L_ORG_CONDITION := ' and org.organization_id in ' || '(select to_char(pose.organization_id_child) '
146: || 'from per_org_structure_elements pose ' || 'connect by pose.organization_id_parent = '
147: || 'prior pose.organization_id_child ' || 'and pose.org_structure_version_id = ' || TO_CHAR(P_ORG_STRUCTURE_VERSION_ID) || ' start with pose.organization_id_parent = ' || TO_CHAR(NVL(P_ORG_ID
148: ,L_PARENT_ID)) || ' and pose.org_structure_version_id = '
149: || TO_CHAR(P_ORG_STRUCTURE_VERSION_ID) || ' union select '
150: || '''' || TO_CHAR(NVL(P_ORG_ID