APPS.JAI_AR_GLDIST_TRIGGER_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 223: , ra_cust_trx_types_all trx_types

219: SELECT trx_types.type
220: FROM
221: ra_customer_trx_lines_all trxl
222: , ra_customer_trx_all trx
223: , ra_cust_trx_types_all trx_types
224: WHERE trxl.customer_trx_id = trx.customer_trx_id
225: AND trx_types.cust_trx_type_id = trx.cust_trx_type_id
226: AND trxl.customer_trx_line_id = cp_customer_trx_line_id;
227:

Line 228: lv_ar_trx_type ra_cust_trx_types_all.type%TYPE;

224: WHERE trxl.customer_trx_id = trx.customer_trx_id
225: AND trx_types.cust_trx_type_id = trx.cust_trx_type_id
226: AND trxl.customer_trx_line_id = cp_customer_trx_line_id;
227:
228: lv_ar_trx_type ra_cust_trx_types_all.type%TYPE;
229: ----------------------------------------------
230: --Added by Wenqiong for Bug 14253668 end
231:
232: /*Bug 14121914 - Fetch the GL Date of the Revenue Line*/