DBA Data[Home] [Help]

APPS.PER_PERDETBU_XMLP_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 22: PER_ORG_STRUCTURE_ELEMENTS POSE,

18: DISTINCT
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 = (

Line 37: PER_ORG_STRUCTURE_ELEMENTS POSE,

33: AND POSE.ORGANIZATION_ID_PARENT not in (
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 = (