APPS.JL_AR_DOC_NUMBERING_PKG dependencies on RA_CUST_TRX_TYPES

Line 308: ra_cust_trx_types rctt

304: -- Fetching the dgi code
305: SELECT lpad(substr(dgi_code,1,2),2,'0')
306: INTO l_dgi_code
307: FROM jl_ar_ap_trx_dgi_codes dgi,
308: ra_cust_trx_types rctt
309: WHERE trx_letter = l_doc_letter
310: AND rctt.cust_trx_type_id = p_trx_type_id
311: AND trx_category = (select type from ra_cust_trx_types where
312: cust_trx_type_id = p_trx_type_id);

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

307: FROM jl_ar_ap_trx_dgi_codes dgi,
308: ra_cust_trx_types rctt
309: WHERE trx_letter = l_doc_letter
310: AND rctt.cust_trx_type_id = p_trx_type_id
311: AND trx_category = (select type from ra_cust_trx_types where
312: cust_trx_type_id = p_trx_type_id);
313: EXCEPTION
314: WHEN OTHERS THEN
315: l_doc_letter := NULL;

Line 770: FROM ra_cust_trx_types

766: END IF;
767: BEGIN
768: SELECT type
769: INTO l_invoice_class
770: FROM ra_cust_trx_types
771: WHERE cust_trx_type_id = p_trx_type;
772: IF PG_DEBUG in ('Y', 'C') THEN
773: arp_standard.debug('validate_interface_lines: ' || '-- the type for the trx type found');
774: END IF;