DBA Data[Home] [Help]

APPS.OZF_SETTLEMENT_DOC_PVT dependencies on AR_ADJUSTMENTS

Line 381: FROM ar_adjustments adj

377: , adj.adjustment_number --"settlement_number"
378: , adj.apply_date --"settlement_date"
379: , adj.amount --"settlement_amount"
380: , pay.status --"status_code"
381: FROM ar_adjustments adj
382: , ar_payment_schedules pay
383: WHERE adj.payment_schedule_id = pay.payment_schedule_id
384: AND adj.adjustment_id = cv_adjust_id;
385:

Line 2691: l_adj_rec AR_ADJUSTMENTS%ROWTYPE;

2687: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
2688: l_return_status VARCHAR2(1);
2689:
2690: l_writeoff_threshold VARCHAR2(15);
2691: l_adj_rec AR_ADJUSTMENTS%ROWTYPE;
2692: l_x_new_adjust_number VARCHAR2(20);
2693: l_x_new_adjust_id NUMBER;
2694: l_payment_schedule_id NUMBER;
2695: l_receivables_trx_id NUMBER;

Line 2711: FROM ar_adjustments adj

2707: , adj.adjustment_number --"settlement_number"
2708: , adj.apply_date --"settlement_date"
2709: , adj.amount --"settlement_amount"
2710: , pay.status --"status_code"
2711: FROM ar_adjustments adj
2712: , ar_payment_schedules pay
2713: WHERE adj.payment_schedule_id = pay.payment_schedule_id
2714: AND adj.adjustment_id = cv_adjust_id;
2715: