DBA Data[Home] [Help]

APPS.PAY_JP_ITAX_ARCHIVE_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 555: from hr_all_organization_units hou,

551: rtrim(substrb(hoi1.org_information6 || hoi1.org_information7 || hoi1.org_information8, 1, 240)) salary_payer_address_kanji,
552: hoi1.org_information1 salary_payer_name_kanji,
553: hoi1.org_information12 salary_payer_telephone_number,
554: hoi2.org_information2 tax_office_number
555: from hr_all_organization_units hou,
556: hr_organization_information hoi1,
557: hr_organization_information hoi2
558: where hou.organization_id = cp_itax_organization_id
559: and hoi1.organization_id(+) = hou.organization_id