APPS.ARP_CHARGEBACK_COVER dependencies on RA_CUST_TRX_TYPES

Line 136: l_cb_trx_type ra_cust_trx_types.name%TYPE;

132: l_api_name CONSTANT VARCHAR2(30)
133: := 'create_chargeback';
134: l_site_required_flag ar_system_parameters.site_required_flag%TYPE := 'N';
135: lp_bill_to_site_use_id NUMBER; --Stores the bill_to_site_id passed from claim
136: l_cb_trx_type ra_cust_trx_types.name%TYPE;
137: l_sequence_name fnd_document_sequences.name%TYPE;
138: l_legal_entity_id ra_customer_trx.legal_entity_id%TYPE;
139:
140: BEGIN

Line 496: FROM ra_cust_trx_types

492: SELECT name,
493: gl_id_rec
494: INTO l_cb_trx_type,
495: l_default_code_combination_id
496: FROM ra_cust_trx_types
497: WHERE cust_trx_type_id = p_chargeback_rec.cust_trx_type_id
498: AND type = 'CB'
499: AND NVL(status,'A') = 'A'
500: AND post_to_gl = 'Y'