DBA Data[Home] [Help]

APPS.ARP_CR_UTIL dependencies on AR_BATCHES

Line 147: p_batch_id OUT NOCOPY ar_batches.batch_id%TYPE) IS

143: --
144:
145:
146: PROCEDURE get_batch_id( p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
147: p_batch_id OUT NOCOPY ar_batches.batch_id%TYPE) IS
148: --
149: BEGIN
150: --
151: IF PG_DEBUG in ('Y', 'C') THEN

Line 163: ar_batches bat

159: --
160: SELECT max(crh.batch_id)
161: INTO p_batch_id
162: FROM ar_cash_receipt_history crh,
163: ar_batches bat
164: WHERE crh.cash_receipt_id = p_cr_id
165: AND crh.first_posted_record_flag = 'Y'
166: AND bat.batch_id = crh.batch_id
167: AND bat.type = 'MANUAL';