DBA Data[Home] [Help]

APPS.PAY_PAYJPITT_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 45: HR_ALL_ORGANIZATION_UNITS HOU

41: CP_EMPLOYER_NAME,
42: CP_EMPLOYER_TELEPHONE_NUMBER
43: FROM HR_ORGANIZATION_INFORMATION HOI2,
44: HR_ORGANIZATION_INFORMATION HOI1,
45: HR_ALL_ORGANIZATION_UNITS HOU
46: WHERE HOU.ORGANIZATION_ID = P_ITAX_ORGANIZATION_ID
47: AND HOI1.ORGANIZATION_ID(+) = HOU.ORGANIZATION_ID
48: AND HOI1.ORG_INFORMATION_CONTEXT(+) = 'JP_TAX_SWOT_INFO'
49: AND HOI2.ORGANIZATION_ID(+) = HOU.ORGANIZATION_ID