APPS.AR_CM_APP_VAL_PVT dependencies on RA_CUSTOMER_TRX

Line 462: FROM ra_customer_trx ct,

458: ct.previous_customer_trx_id,
459: ct.complete_flag,
460: rc.remit_flag,
461: rma.remittance_ccid
462: FROM ra_customer_trx ct,
463: ar_receipt_methods rm,
464: ar_receipt_classes rc,
465: ar_receipt_method_accounts rma
466: WHERE ct.customer_trx_id = p_customer_trx_id

Line 480: l_complete_flag ra_customer_trx.complete_flag%TYPE;

476:
477: l_receipt_method_id NUMBER;
478: l_customer_bank_account_id NUMBER;
479: l_previous_customer_trx_id NUMBER;
480: l_complete_flag ra_customer_trx.complete_flag%TYPE;
481: l_remit_flag ar_receipt_classes.remit_flag%TYPE;
482: l_remittance_ccid NUMBER;
483: l_amount_due_original NUMBER;
484: l_amount_due_remaining NUMBER;