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 2179: c_org_name hr_all_organization_units_tl.name%TYPE;

2175: c_item_id NUMBER := NULL;
2176: v_progress VARCHAR2(3);
2177:
2178: v_po_num po_headers_archive_all.segment1%TYPE;
2179: c_org_name hr_all_organization_units_tl.name%TYPE;
2180: c_entity_id NUMBER;
2181: c_entity_type po_price_differentials_archive.entity_type%TYPE;
2182: c_price_diff_num po_price_differentials_archive.price_differential_num%TYPE;
2183:

Line 2447: c_org_name hr_all_organization_units_tl.name%TYPE;

2443: c_item_id NUMBER := NULL;
2444: v_progress VARCHAR2(3);
2445:
2446: v_po_num po_headers_archive_all.segment1%TYPE;
2447: c_org_name hr_all_organization_units_tl.name%TYPE;
2448: c_enabled_org_id NUMBER;
2449:
2450: BEGIN
2451:

Line 2479: from HR_ALL_ORGANIZATION_UNITS_TL HAOTL

2475: where ood.organization_id = c_enabled_org_id;
2476: */
2477: select HAOTL.NAME
2478: into c_org_name
2479: from HR_ALL_ORGANIZATION_UNITS_TL HAOTL
2480: where HAOTL.ORGANIZATION_ID = c_enabled_org_id and
2481: HAOTL.LANGUAGE = USERENV('LANG');
2482:
2483: