APPS.PER_PERSAIPE_XMLP_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 132: PER_ORG_STRUCTURE_ELEMENTS POSE

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

Line 138: PER_ORG_STRUCTURE_ELEMENTS POSE1

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

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

143: END;
144: END IF;
145: IF L_ERR = 0 THEN
146: L_ORG_CONDITION := ' and org.organization_id in ' || '(select to_char(pose.organization_id_child) '
147: || 'from per_org_structure_elements pose ' || 'connect by pose.organization_id_parent = '
148: || '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
149: ,L_PARENT_ID)) || ' and pose.org_structure_version_id = '
150: || TO_CHAR(P_ORG_STRUCTURE_VERSION_ID) || ' union select '
151: || '''' || TO_CHAR(NVL(P_ORG_ID