APPS.ARP_CREDIT_MEMO_MODULE dependencies on AR_PAYMENT_SCHEDULES

Line 5435: ar_payment_schedules ps

5431: ps.selected_for_receipt_batch_id,
5432: int.cust_trx_type_id,
5433: int.amount
5434: FROM ra_interface_lines int,
5435: ar_payment_schedules ps
5436: WHERE int.request_id = p_request_id
5437: AND int.previous_customer_trx_id IS NOT NULL
5438: AND int.previous_customer_trx_id = ps.customer_trx_id ;
5439:

Line 5492: FROM ar_payment_schedules

5488:
5489: BEGIN
5490: SELECT 'Y'
5491: INTO l_locked
5492: FROM ar_payment_schedules
5493: WHERE payment_schedule_id = i.payment_schedule_id
5494: --AND selected_for_receipt_batch_id IS NULL /* Bug fix 3142217 */
5495: --Commented The Above Line And Added The Following 3 Lines For Bug Fix 6339084
5496: /*Bug Fix 6339084 Starts */