DBA Data[Home] [Help]

APPS.GHR_GHRCPDFO_XMLP_PKG dependencies on PER_POSITIONS

Line 64: PER_POSITIONS PPOS,

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
68: AND PPOS.POSITION_ID = PPEI.POSITION_ID

Line 101: PER_POSITIONS PPOS,

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
105: AND PPOS.POSITION_ID = PPEI.POSITION_ID

Line 140: PER_POSITIONS PPOS,

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
144: AND OEI.ORGANIZATION_ID = HRU.ORGANIZATION_ID