APPS.AR_RECEIPT_API_PUB dependencies on AR_CASH_RECEIPT_HISTORY_S

Line 10672: ar_cash_receipt_history_s.nextval,

10668: select cash_receipt_history_id,
10669: cash_receipt_id,
10670: reversal_gl_date,
10671: gl_date,
10672: ar_cash_receipt_history_s.nextval,
10673: batch_id,
10674: amount,
10675: cc_error_code,
10676: cc_error_text,

Line 10956: update ar_cash_receipt_history set

10952:
10953:
10954: /*Update existing CRH record of remittance*/
10955: FORALL i in l_crh_upd.cash_receipt_history_id.first..l_crh_upd.cash_receipt_history_id.last
10956: update ar_cash_receipt_history set
10957: reversal_cash_receipt_hist_id = l_crh_upd.reversal_cash_receipt_hist_id(i),
10958: reversal_gl_date = l_crh_upd.reversal_gl_date(i),
10959: reversal_created_from = 'ARREVREM',
10960: current_record_flag = NULL,

Line 11109: update ar_cash_receipt_history set

11105:
11106: IF l_request_id_bulk = -999 THEN
11107:
11108: FORALL i in l_crh_upd.cash_receipt_history_id.first..l_crh_upd.cash_receipt_history_id.last
11109: update ar_cash_receipt_history set
11110: request_id = l_request_id
11111: WHERE cash_receipt_history_id = l_crh_upd.reversal_cash_receipt_hist_id(i)
11112: AND current_record_flag = 'Y'
11113: AND status = 'CONFIRMED'

Line 11346: update ar_cash_receipt_history SET

11342: IF PG_DEBUG in ('Y','C') THEN
11343: arp_standard.debug ( 'NO of Receipts updated = '|| to_char(SQL%ROWCOUNT));
11344: END IF;
11345:
11346: update ar_cash_receipt_history SET
11347: last_update_date = sysdate,
11348: request_id = p_request_id
11349: WHERE cash_receipt_id in
11350: ( select cash_receipt_id