DBA Data[Home] [Help]

APPS.OZF_SETTLEMENT_DOC_PVT dependencies on AR_ADJUSTMENTS

Line 234: FROM ar_adjustments adj

230: , adj.adjustment_number --"settlement_number"
231: , adj.apply_date --"settlement_date"
232: , adj.amount --"settlement_amount"
233: , pay.status --"status_code"
234: FROM ar_adjustments adj
235: , ar_payment_schedules pay
236: WHERE adj.payment_schedule_id = pay.payment_schedule_id
237: AND adj.adjustment_id = cv_adjust_id;
238:

Line 2219: l_adj_rec AR_ADJUSTMENTS%ROWTYPE;

2215: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
2216: l_return_status VARCHAR2(1);
2217:
2218: l_writeoff_threshold VARCHAR2(15);
2219: l_adj_rec AR_ADJUSTMENTS%ROWTYPE;
2220: l_x_new_adjust_number VARCHAR2(20);
2221: l_x_new_adjust_id NUMBER;
2222: l_payment_schedule_id NUMBER;
2223: l_receivables_trx_id NUMBER;

Line 2239: FROM ar_adjustments adj

2235: , adj.adjustment_number --"settlement_number"
2236: , adj.apply_date --"settlement_date"
2237: , adj.amount --"settlement_amount"
2238: , pay.status --"status_code"
2239: FROM ar_adjustments adj
2240: , ar_payment_schedules pay
2241: WHERE adj.payment_schedule_id = pay.payment_schedule_id
2242: AND adj.adjustment_id = cv_adjust_id;
2243: