DBA Data[Home] [Help]

APPS.JL_AR_DOC_NUMBERING_PKG dependencies on JL_AR_AP_TRX_DGI_CODES

Line 307: FROM jl_ar_ap_trx_dgi_codes dgi,

303:
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