APPS.ARP_BR_REMIT_BATCHES dependencies on AR_CASH_RECEIPT_HISTORY

Line 1276: p_batch_id IN ar_cash_receipt_history.batch_id%TYPE) IS

1272: | 5-SEP-2000 Jani Rautiainen Created |
1273: | |
1274: +===========================================================================*/
1275: PROCEDURE update_br_remit_batch_to_crh(p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1276: p_batch_id IN ar_cash_receipt_history.batch_id%TYPE) IS
1277:
1278: /*--------------------------------------------+
1279: | Cursor to fetch the current cash receipt |
1280: | history record |

Line 1284: FROM ar_cash_receipt_history

1280: | history record |
1281: +--------------------------------------------*/
1282: CURSOR receipt_cur IS
1283: SELECT cash_receipt_history_id
1284: FROM ar_cash_receipt_history
1285: WHERE cash_receipt_id = p_cr_id
1286: AND current_record_flag = 'Y';
1287:
1288: receipt_rec receipt_cur%ROWTYPE;

Line 1289: l_crh_rec ar_cash_receipt_history%ROWTYPE;

1285: WHERE cash_receipt_id = p_cr_id
1286: AND current_record_flag = 'Y';
1287:
1288: receipt_rec receipt_cur%ROWTYPE;
1289: l_crh_rec ar_cash_receipt_history%ROWTYPE;
1290: l_crh_id ar_cash_receipt_history.cash_Receipt_history_id%TYPE;
1291:
1292: BEGIN
1293: IF PG_DEBUG in ('Y', 'C') THEN

Line 1290: l_crh_id ar_cash_receipt_history.cash_Receipt_history_id%TYPE;

1286: AND current_record_flag = 'Y';
1287:
1288: receipt_rec receipt_cur%ROWTYPE;
1289: l_crh_rec ar_cash_receipt_history%ROWTYPE;
1290: l_crh_id ar_cash_receipt_history.cash_Receipt_history_id%TYPE;
1291:
1292: BEGIN
1293: IF PG_DEBUG in ('Y', 'C') THEN
1294: arp_standard.debug('arp_br_remit_batches.update_br_remit_batch_to_crh()+');