APPS.PO_EMAIL_GENERATE dependencies on HR_ORGANIZATION_INFORMATION

Line 3165: from hr_organization_information

3161: select name
3162: into l_company_name
3163: from hr_all_organization_units
3164: where organization_id = (select to_number(org_information2)
3165: from hr_organization_information
3166: where org_information_context = 'Operating Unit Information'
3167: and organization_id = l_operating_unit_id);
3168: -- EMAILPO FPH--
3169: -- retrieve correct region instead of just state and also print country in non abbreviated form