APPS.RCV_GAPLESS_NUMBERING dependencies on HR_ORGANIZATION_UNITS

Line 37: l_organization_name HR_ORGANIZATION_UNITS.NAME%TYPE;

33: l_return_status VARCHAR2 (1);
34: l_msg_data VARCHAR2 (2000);
35: l_msg_count NUMBER;
36: l_vendor_id NUMBER;
37: l_organization_name HR_ORGANIZATION_UNITS.NAME%TYPE;
38: l_organization_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
39: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;
40: l_vendor_site_code PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE;
41: l_org_code_name VARCHAR2(300);

Line 112: FROM hr_organization_units

108:
109: BEGIN
110: SELECT name
111: INTO l_organization_name
112: FROM hr_organization_units
113: WHERE organization_id = p_org_id;
114:
115: IF (g_asn_debug = 'Y')
116: THEN