APPS.PER_PERSAIQE_XMLP_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 130: PER_ORG_STRUCTURE_ELEMENTS POSE

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

Line 136: PER_ORG_STRUCTURE_ELEMENTS POSE1

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

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

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