DBA Data[Home] [Help]

APPS.PAY_JP_ITAX_ARCHIVE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 556: hr_organization_information hoi1,

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
560: and hoi1.org_information_context(+) = 'JP_TAX_SWOT_INFO'

Line 557: hr_organization_information hoi2

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
560: and hoi1.org_information_context(+) = 'JP_TAX_SWOT_INFO'
561: and hoi2.organization_id(+) = hou.organization_id