DBA Data[Home] [Help]

APPS.PAY_JP_ITAX_ARCHIVE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 546: hr_organization_information hoi1,

542: hoi1.org_information1 salary_payer_name_kanji,
543: hoi1.org_information12 salary_payer_telephone_number,
544: hoi2.org_information2 tax_office_number
545: from hr_all_organization_units hou,
546: hr_organization_information hoi1,
547: hr_organization_information hoi2
548: where hou.organization_id = cp_itax_organization_id
549: and hoi1.organization_id(+) = hou.organization_id
550: and hoi1.org_information_context(+) = 'JP_TAX_SWOT_INFO'

Line 547: hr_organization_information hoi2

543: hoi1.org_information12 salary_payer_telephone_number,
544: hoi2.org_information2 tax_office_number
545: from hr_all_organization_units hou,
546: hr_organization_information hoi1,
547: hr_organization_information hoi2
548: where hou.organization_id = cp_itax_organization_id
549: and hoi1.organization_id(+) = hou.organization_id
550: and hoi1.org_information_context(+) = 'JP_TAX_SWOT_INFO'
551: and hoi2.organization_id(+) = hou.organization_id