APPS.ARP_BR_REMIT_BATCHES dependencies on AR_PAYMENT_SCHEDULES

Line 992: l_ps_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;

988: p_batch_id IN AR_BATCHES.batch_id%TYPE,
989: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
990:
991: l_batch_rec AR_BATCHES%ROWTYPE;
992: l_ps_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
993:
994: l_new_status AR_TRANSACTION_HISTORY.status%TYPE;
995:
996:

Line 999: FROM AR_PAYMENT_SCHEDULES

995:
996:
997: CURSOR cur_br IS
998: SELECT payment_schedule_id
999: FROM AR_PAYMENT_SCHEDULES
1000: WHERE reserved_type = 'REMITTANCE'
1001: AND reserved_value = p_batch_id;
1002:
1003: BEGIN