APPS.AR_CM_APP_VAL_PVT dependencies on RA_CUSTOMER_TRX

Line 466: FROM ra_customer_trx ct,

462: ct.previous_customer_trx_id,
463: ct.complete_flag,
464: rc.remit_flag,
465: rma.remittance_ccid
466: FROM ra_customer_trx ct,
467: ar_receipt_methods rm,
468: ar_receipt_classes rc,
469: ar_receipt_method_accounts rma
470: WHERE ct.customer_trx_id = p_customer_trx_id

Line 484: l_complete_flag ra_customer_trx.complete_flag%TYPE;

480:
481: l_receipt_method_id NUMBER;
482: l_customer_bank_account_id NUMBER;
483: l_previous_customer_trx_id NUMBER;
484: l_complete_flag ra_customer_trx.complete_flag%TYPE;
485: l_remit_flag ar_receipt_classes.remit_flag%TYPE;
486: l_remittance_ccid NUMBER;
487: l_amount_due_original NUMBER;
488: l_amount_due_remaining NUMBER;