APPS.ARP_DEDUCTION dependencies on RA_CUSTOMER_TRX

Line 286: --Get TRX based info from ra_customer_trx and ar_payment_schedules

282: AND ra.status = 'APP'
283: AND ra.display = 'Y'
284: AND ra.request_id = p_request_id;
285:
286: --Get TRX based info from ra_customer_trx and ar_payment_schedules
287: --Exclude CLASS=PMT
288: CURSOR get_ps_trx_info
289: (p_trx_ps_id ar_receivable_applications.applied_payment_schedule_id%type
290: ) IS

Line 307: FROM ra_customer_trx ct

303: ,ps.amount_due_original --amount_due_original
304: ,ps.class --class
305: ,ps.active_claim_flag --active_claim_flag
306: ,ct.legal_entity_id
307: FROM ra_customer_trx ct
308: ,ar_payment_schedules ps
309: WHERE ct.customer_trx_id = ps.customer_trx_id
310: AND ps.payment_schedule_id = p_trx_ps_id
311: AND ps.class <> 'PMT';

Line 489: l_customer_trx_id ra_customer_trx.customer_trx_id%type;

485: l_amount_due_remaining ar_payment_schedules_all.amount_due_remaining%type;
486: l_amount_due_original ar_payment_schedules_all.amount_due_original%type;
487: l_class ar_payment_schedules_all.class%type;
488: l_claim_amount NUMBER;
489: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
490: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
491: l_trx_number ra_customer_trx.trx_number%type;
492: l_salesrep_id ra_customer_trx.primary_salesrep_id%type;
493: l_index NUMBER;

Line 491: l_trx_number ra_customer_trx.trx_number%type;

487: l_class ar_payment_schedules_all.class%type;
488: l_claim_amount NUMBER;
489: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
490: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
491: l_trx_number ra_customer_trx.trx_number%type;
492: l_salesrep_id ra_customer_trx.primary_salesrep_id%type;
493: l_index NUMBER;
494: l_bulk_fetch_rows NUMBER := 400;
495: l_last_fetch BOOLEAN := FALSE;

Line 492: l_salesrep_id ra_customer_trx.primary_salesrep_id%type;

488: l_claim_amount NUMBER;
489: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
490: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
491: l_trx_number ra_customer_trx.trx_number%type;
492: l_salesrep_id ra_customer_trx.primary_salesrep_id%type;
493: l_index NUMBER;
494: l_bulk_fetch_rows NUMBER := 400;
495: l_last_fetch BOOLEAN := FALSE;
496: l_claim_status ar_payment_schedules.active_claim_flag%type;