DBA Data[Home] [Help]

APPS.GHR_GHRCPDFO_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 62: HR_ORGANIZATION_UNITS HRU,

58: PPDK.SEGMENT4 AGENCY_SUBELEMENT
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

Line 99: HR_ORGANIZATION_UNITS HRU,

95: OEI.ORGANIZATION_ID ID,
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

Line 138: HR_ORGANIZATION_UNITS HRU,

134: FROM
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