APPS.PO_EMAIL_GENERATE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2695: l_company_name hr_all_organization_units.name%TYPE;

2691: /** **/
2692: /** tpoon 9/27/2002 **/
2693: /** Changed x_ship_to_organization_name to use %TYPE **/
2694: -- l_company_name varchar2(60);
2695: l_company_name hr_all_organization_units.name%TYPE;
2696:
2697: l_requestor_count NUMBER := 0;
2698: l_multiple_flag varchar2(1);
2699: l_start_date varchar2(80);

Line 3598: from hr_all_organization_units

3594: /* Bug - 1774523 - Changed the query to get the legal entity name */
3595: -- bug 4969659 - removed to_char on organization_id to prevent FTS
3596: /*select name
3597: into l_company_name
3598: from hr_all_organization_units
3599: where organization_id = (select to_number(org_information2)
3600: from hr_organization_information
3601: where org_information_context = 'Operating Unit Information'
3602: and organization_id = l_operating_unit_id);*/