APPS.PO_EMAIL_GENERATE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2474: l_company_name hr_all_organization_units.name%TYPE;

2470: /** **/
2471: /** tpoon 9/27/2002 **/
2472: /** Changed x_ship_to_organization_name to use %TYPE **/
2473: -- l_company_name varchar2(60);
2474: l_company_name hr_all_organization_units.name%TYPE;
2475:
2476: l_requestor_count NUMBER := 0;
2477: l_multiple_flag varchar2(1);
2478: l_start_date po_headers.start_date%type;

Line 3163: from hr_all_organization_units

3159: /* Bug - 1774523 - Changed the query to get the legal entity name */
3160: -- bug 4969659 - removed to_char on organization_id to prevent FTS
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);