APPS.PER_PERDETBU_XMLP_PKG dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 23: PER_ORG_STRUCTURE_VERSIONS POSV

19: POSE.ORGANIZATION_ID_PARENT
20: INTO L_TOP_ORG_ID
21: FROM
22: PER_ORG_STRUCTURE_ELEMENTS POSE,
23: PER_ORG_STRUCTURE_VERSIONS POSV
24: WHERE POSE.ORG_STRUCTURE_VERSION_ID = POSV.ORG_STRUCTURE_VERSION_ID
25: AND POSV.ORGANIZATION_STRUCTURE_ID = P_ORG_HIERARCHY
26: AND POSV.VERSION_NUMBER = (
27: SELECT

Line 30: PER_ORG_STRUCTURE_VERSIONS POSV

26: AND POSV.VERSION_NUMBER = (
27: SELECT
28: MAX(VERSION_NUMBER)
29: FROM
30: PER_ORG_STRUCTURE_VERSIONS POSV
31: WHERE POSV.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
32: AND POSV.ORGANIZATION_STRUCTURE_ID = P_ORG_HIERARCHY )
33: AND POSE.ORGANIZATION_ID_PARENT not in (
34: SELECT

Line 38: PER_ORG_STRUCTURE_VERSIONS POSV

34: SELECT
35: POSE.ORGANIZATION_ID_CHILD
36: FROM
37: PER_ORG_STRUCTURE_ELEMENTS POSE,
38: PER_ORG_STRUCTURE_VERSIONS POSV
39: WHERE POSE.ORG_STRUCTURE_VERSION_ID = POSV.ORG_STRUCTURE_VERSION_ID
40: AND POSV.ORGANIZATION_STRUCTURE_ID = P_ORG_HIERARCHY
41: AND POSV.VERSION_NUMBER = (
42: SELECT

Line 45: PER_ORG_STRUCTURE_VERSIONS POSV

41: AND POSV.VERSION_NUMBER = (
42: SELECT
43: MAX(VERSION_NUMBER)
44: FROM
45: PER_ORG_STRUCTURE_VERSIONS POSV
46: WHERE POSV.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
47: AND POSV.ORGANIZATION_STRUCTURE_ID = P_ORG_HIERARCHY ) );
48: P_TOP_ORG := L_TOP_ORG_ID;
49: EXCEPTION