DBA Data[Home] [Help]

APPS.PAY_PAYJPITT_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 43: FROM HR_ORGANIZATION_INFORMATION HOI2,

39: CP_EMPLOYER_POSTAL_CODE,
40: CP_EMPLOYER_ADDRESS,
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

Line 44: HR_ORGANIZATION_INFORMATION HOI1,

40: CP_EMPLOYER_ADDRESS,
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'