APPS.PAY_PAYJPWTM_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 157: HR_ALL_ORGANIZATION_UNITS HOU

153: INTO CP_HQ_EMPLOYER_ADDRESS,CP_HQ_EMPLOYER_NAME,CP_HQ_REFERENCE_NUMBER1,CP_HQ_REFERENCE_NUMBER2
154: FROM
155: HR_ORGANIZATION_INFORMATION HOI2,
156: HR_ORGANIZATION_INFORMATION HOI1,
157: HR_ALL_ORGANIZATION_UNITS HOU
158: WHERE HOU.ORGANIZATION_ID = P_ITAX_ORGANIZATION_ID
159: AND hoi1.organization_id (+) = HOU.ORGANIZATION_ID
160: AND hoi1.org_information_context (+) = 'JP_TAX_SWOT_INFO'
161: AND hoi2.organization_id (+) = HOU.ORGANIZATION_ID

Line 623: HR_ALL_ORGANIZATION_UNITS HOU

619: ,15))
620: INTO CP_EMPLOYER_ADDRESS,CP_EMPLOYER_NAME,CP_EMPLOYER_TELEPHONE_NUMBER
621: FROM
622: HR_ORGANIZATION_INFORMATION HOI,
623: HR_ALL_ORGANIZATION_UNITS HOU
624: WHERE HOU.ORGANIZATION_ID = ITAX_ORGANIZATION_ID
625: AND hoi.organization_id (+) = HOU.ORGANIZATION_ID
626: AND hoi.org_information_context (+) = 'JP_TAX_SWOT_INFO';
627: RETURN NULL;