DBA Data[Home] [Help]

APPS.PAY_PAYJPWTM_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 155: HR_ORGANIZATION_INFORMATION HOI2,

151: ,13)
152: ,'0')
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

Line 156: HR_ORGANIZATION_INFORMATION HOI1,

152: ,'0')
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'

Line 622: HR_ORGANIZATION_INFORMATION HOI,

618: ,' ')
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';