APPS.POS_COMPARE_REVISIONS dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 332: v_org_name hr_all_organization_units_tl.name%TYPE;

328: ********************************************************************/
329: FUNCTION get_organization( p_org_id IN NUMBER )
330: RETURN VARCHAR2 AS
331:
332: v_org_name hr_all_organization_units_tl.name%TYPE;
333: v_progress varchar2(3);
334:
335: BEGIN
336:

Line 348: from HR_ALL_ORGANIZATION_UNITS_TL HAOTL

344: where ood.organization_id = p_org_id;
345: */
346: select HAOTL.NAME
347: into v_org_name
348: from HR_ALL_ORGANIZATION_UNITS_TL HAOTL
349: where HAOTL.ORGANIZATION_ID = p_org_id and
350: HAOTL.LANGUAGE = USERENV('LANG');
351:
352:

Line 2175: c_org_name hr_all_organization_units_tl.name%TYPE;

2171: c_item_id NUMBER := NULL;
2172: v_progress VARCHAR2(3);
2173:
2174: v_po_num po_headers_archive_all.segment1%TYPE;
2175: c_org_name hr_all_organization_units_tl.name%TYPE;
2176: c_entity_id NUMBER;
2177: c_entity_type po_price_differentials_archive.entity_type%TYPE;
2178: c_price_diff_num po_price_differentials_archive.price_differential_num%TYPE;
2179:

Line 2443: c_org_name hr_all_organization_units_tl.name%TYPE;

2439: c_item_id NUMBER := NULL;
2440: v_progress VARCHAR2(3);
2441:
2442: v_po_num po_headers_archive_all.segment1%TYPE;
2443: c_org_name hr_all_organization_units_tl.name%TYPE;
2444: c_enabled_org_id NUMBER;
2445:
2446: BEGIN
2447:

Line 2475: from HR_ALL_ORGANIZATION_UNITS_TL HAOTL

2471: where ood.organization_id = c_enabled_org_id;
2472: */
2473: select HAOTL.NAME
2474: into c_org_name
2475: from HR_ALL_ORGANIZATION_UNITS_TL HAOTL
2476: where HAOTL.ORGANIZATION_ID = c_enabled_org_id and
2477: HAOTL.LANGUAGE = USERENV('LANG');
2478:
2479: