DBA Data[Home] [Help]

APPS.OZF_AR_SETTLEMENT_PVT dependencies on AR_ADJUSTMENTS

Line 870: FROM ar_adjustments

866:
867: -- Cursor to verify Write_Off number
868: CURSOR csr_write_off_trx(cv_trx_number IN VARCHAR2) IS
869: SELECT adjustment_id
870: FROM ar_adjustments
871: WHERE adjustment_number = cv_trx_number;
872:
873: l_trx_id NUMBER := NULL;
874: l_trx_number_name VARCHAR2(30);

Line 914: FROM ar_adjustments adj

910: , adj.adjustment_number --"settlement_number"
911: , adj.apply_date --"settlement_date"
912: , adj.amount --"settlement_amount"
913: , pay.status --"status_code"
914: FROM ar_adjustments adj
915: , ar_payment_schedules pay
916: WHERE adj.payment_schedule_id = pay.payment_schedule_id
917: AND adj.adjustment_id = cv_trx_id;
918: