APPS.IGI_EXP_UTILS dependencies on RA_CUST_TRX_TYPES_ALL

Line 264: , ra_cust_trx_types_all ctt

260: , ctt.creation_sign
261: , ctt.allow_overapplication_flag
262: , ctt.natural_application_only_flag
263: FROM ra_customer_trx_all trx
264: , ra_cust_trx_types_all ctt
265: WHERE trx.customer_trx_id = p_trx_id
266: AND trx.cust_trx_type_id = ctt.cust_trx_type_id
267: AND trx.org_id = ctt.org_id;
268:

Line 273: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%TYPE;

269: l_previous_customer_trx_id ra_customer_trx.previous_customer_trx_id%TYPE;
270: l_complete_flag ra_customer_trx.complete_flag%TYPE;
271: l_trx_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%TYPE;
272: l_creation_sign ra_cust_trx_types.creation_sign%TYPE;
273: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%TYPE;
274: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%TYPE;
275: p_error_message VARCHAR2(2000);
276:
277:

Line 282: , ra_cust_trx_types_all ctt

278: CURSOR c_get_prev_trx_info(p_trx_id RA_CUSTOMER_TRX.CUSTOMER_TRX_ID%TYPE)
279: IS
280: SELECT ctt.accounting_affect_flag
281: FROM ra_customer_trx_all trx
282: , ra_cust_trx_types_all ctt
283: WHERE trx.customer_trx_id = p_trx_id
284: AND trx.cust_trx_type_id = ctt.cust_trx_type_id
285: AND trx.org_id = ctt.org_id;
286:

Line 783: , ra_cust_trx_types_all rctt

779: , arl.meaning
780: FROM ra_customer_trx_all rct
781: , igi_exp_ar_trans i
782: , ar_lookups arl
783: , ra_cust_trx_types_all rctt
784: WHERE i.du_id = pv_du_id
785: AND rct.customer_trx_id = i.customer_trx_id
786: AND rctt.cust_trx_type_id = rct.cust_trx_type_id
787: AND rctt.org_id = rct.org_id