DBA Data[Home] [Help]

APPS.ARP_CORRECT_CC_ERRORS dependencies on RA_CUSTOMER_TRX_ALL

Line 646: UPDATE ra_customer_trx_all

642: and raco_bill_rel.status(+) = 'A'
643: and ct.primary_salesrep_id = ra_sales.salesrep_id (+)
644: and ct.customer_trx_id = p_customer_trx_id;
645:
646: UPDATE ra_customer_trx_all
647: SET payment_trxn_extension_id = NULL,
648: receipt_method_id = NULL,
649: cc_error_flag = NULL,
650: last_update_date = sysdate,

Line 2549: UPDATE ra_customer_trx_all

2545:
2546:
2547: ELSE
2548: /* i) update receipt_method and payment info of inv to null */
2549: UPDATE ra_customer_trx_all
2550: SET payment_trxn_extension_id = NULL,
2551: receipt_method_id = NULL,
2552: cc_error_flag = NULL,
2553: last_update_date = sysdate,