APPS.JL_AR_DOC_NUMBERING_PKG dependencies on RA_CUST_TRX_TYPES

Line 301: ra_cust_trx_types rctt

297: -- Fetching the dgi code
298: SELECT lpad(substr(dgi_code,1,2),2,'0')
299: INTO l_dgi_code
300: FROM jl_ar_ap_trx_dgi_codes dgi,
301: ra_cust_trx_types rctt
302: WHERE trx_letter = l_doc_letter
303: AND rctt.cust_trx_type_id = p_trx_type_id
304: AND trx_category = (select type from ra_cust_trx_types where
305: cust_trx_type_id = p_trx_type_id);

Line 304: AND trx_category = (select type from ra_cust_trx_types where

300: FROM jl_ar_ap_trx_dgi_codes dgi,
301: ra_cust_trx_types rctt
302: WHERE trx_letter = l_doc_letter
303: AND rctt.cust_trx_type_id = p_trx_type_id
304: AND trx_category = (select type from ra_cust_trx_types where
305: cust_trx_type_id = p_trx_type_id);
306: EXCEPTION
307: WHEN OTHERS THEN
308: l_doc_letter := NULL;

Line 756: FROM ra_cust_trx_types

752: END IF;
753: BEGIN
754: SELECT type
755: INTO l_invoice_class
756: FROM ra_cust_trx_types
757: WHERE cust_trx_type_id = p_trx_type;
758: IF PG_DEBUG in ('Y', 'C') THEN
759: arp_standard.debug('validate_interface_lines: ' || '-- the type for the trx type found');
760: END IF;