APPS.PO_R12_CAT_UPG_FINAL_GRP dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 2423: l_ou_name HR_ALL_ORGANIZATION_UNITS_TL.name%TYPE;

2419: l_progress VARCHAR2(3) := '000';
2420:
2421: l_long_text LONG := NULL;
2422: l_gbpa_number PO_HEADERS_ALL.segment1%TYPE;
2423: l_ou_name HR_ALL_ORGANIZATION_UNITS_TL.name%TYPE;
2424: l_gbpa_info LONG;
2425:
2426: -- Bug 4941073:
2427: -- GSCC Error: File.SQL.10: Do not use CHR character function in sql scripts

Line 2460: HR_ALL_ORGANIZATION_UNITS_TL HROUTL

2456: HROUTL.name
2457: INTO l_gbpa_number,
2458: l_ou_name
2459: FROM PO_HEADERS_ALL POH,
2460: HR_ALL_ORGANIZATION_UNITS_TL HROUTL
2461: WHERE POH.po_header_id = p_gbpa_header_id_list(i)
2462: AND HROUTL.organization_id = POH.org_id
2463: AND HROUTL.language = userenv('LANG');
2464: