APPS.ARP_BR_REMIT_BATCHES dependencies on AR_CASH_RECEIPT_HISTORY

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

1314: | 5-SEP-2000 Jani Rautiainen Created |
1315: | |
1316: +===========================================================================*/
1317: PROCEDURE update_br_remit_batch_to_crh(p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1318: p_batch_id IN ar_cash_receipt_history.batch_id%TYPE) IS
1319:
1320: /*--------------------------------------------+
1321: | Cursor to fetch the current cash receipt |
1322: | history record |

Line 1326: FROM ar_cash_receipt_history

1322: | history record |
1323: +--------------------------------------------*/
1324: CURSOR receipt_cur IS
1325: SELECT cash_receipt_history_id
1326: FROM ar_cash_receipt_history
1327: WHERE cash_receipt_id = p_cr_id
1328: AND current_record_flag = 'Y';
1329:
1330: receipt_rec receipt_cur%ROWTYPE;

Line 1331: l_crh_rec ar_cash_receipt_history%ROWTYPE;

1327: WHERE cash_receipt_id = p_cr_id
1328: AND current_record_flag = 'Y';
1329:
1330: receipt_rec receipt_cur%ROWTYPE;
1331: l_crh_rec ar_cash_receipt_history%ROWTYPE;
1332: l_crh_id ar_cash_receipt_history.cash_Receipt_history_id%TYPE;
1333:
1334: BEGIN
1335: IF PG_DEBUG in ('Y', 'C') THEN

Line 1332: l_crh_id ar_cash_receipt_history.cash_Receipt_history_id%TYPE;

1328: AND current_record_flag = 'Y';
1329:
1330: receipt_rec receipt_cur%ROWTYPE;
1331: l_crh_rec ar_cash_receipt_history%ROWTYPE;
1332: l_crh_id ar_cash_receipt_history.cash_Receipt_history_id%TYPE;
1333:
1334: BEGIN
1335: IF PG_DEBUG in ('Y', 'C') THEN
1336: arp_standard.debug('arp_br_remit_batches.update_br_remit_batch_to_crh()+');