DBA Data[Home] [Help]

APPS.GHR_GHRCPDFO_XMLP_PKG dependencies on PER_POSITION_EXTRA_INFO

Line 63: PER_POSITION_EXTRA_INFO PPEI,

59: FROM
60: PER_ORGANIZATION_UNITS ORG,
61: HR_ORGANIZATION_INFORMATION OEI,
62: HR_ORGANIZATION_UNITS HRU,
63: PER_POSITION_EXTRA_INFO PPEI,
64: PER_POSITIONS PPOS,
65: PER_POSITION_DEFINITIONS PPDK
66: WHERE OEI.ORGANIZATION_ID = ORG.ORGANIZATION_ID
67: AND PPOS.ORGANIZATION_ID = OEI.ORGANIZATION_ID

Line 100: PER_POSITION_EXTRA_INFO PPEI,

96: HRU.ORGANIZATION_ID ORG_ID
97: FROM
98: HR_ORGANIZATION_INFORMATION OEI,
99: HR_ORGANIZATION_UNITS HRU,
100: PER_POSITION_EXTRA_INFO PPEI,
101: PER_POSITIONS PPOS,
102: PER_POSITION_DEFINITIONS PPDK
103: WHERE OEI.ORGANIZATION_ID = P_ID
104: AND PPOS.ORGANIZATION_ID = OEI.ORGANIZATION_ID

Line 139: PER_POSITION_EXTRA_INFO PPEI,

135: PER_ORG_STRUCTURE_ELEMENTS A,
136: PER_ORG_STRUCTURE_VERSIONS B,
137: HR_ORGANIZATION_INFORMATION OEI,
138: HR_ORGANIZATION_UNITS HRU,
139: PER_POSITION_EXTRA_INFO PPEI,
140: PER_POSITIONS PPOS,
141: PER_POSITION_DEFINITIONS PPDK
142: WHERE A.ORG_STRUCTURE_VERSION_ID = B.ORG_STRUCTURE_VERSION_ID
143: AND PPOS.ORGANIZATION_ID = OEI.ORGANIZATION_ID