DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_ARCHIVE_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 194: from hr_all_organization_units hou,

190: select /*+ ORDERED */
191: hoi2.org_information1 tax_office_name,
192: hoi1.org_information1 salary_payer_name,
193: hoi1.org_information6||hoi1.org_information7||hoi1.org_information8 salary_payer_address
194: from hr_all_organization_units hou,
195: hr_organization_information hoi1,
196: hr_organization_information hoi2
197: where hou.organization_id = g_organization_id
198: and hoi1.organization_id(+) = hou.organization_id