APPS.OZF_AR_VALIDATION_PVT dependencies on AR_PAYMENT_SCHEDULES

Line 176: FROM ar_payment_schedules

172: , trx_number
173: , amount_line_items_remaining
174: , tax_remaining
175: , freight_remaining
176: FROM ar_payment_schedules
177: WHERE customer_trx_id = cv_customer_trx_id;
178:
179:
180: l_payment_schedule_id NUMBER;

Line 284: SELECT trx_number from ar_payment_schedules_all

280: FROM ra_customer_trx_lines
281: WHERE customer_trx_line_id = cv_invoice_line_id;
282:
283: CURSOR csr_trx_details(cv_customer_trx_id IN NUMBER) IS
284: SELECT trx_number from ar_payment_schedules_all
285: WHERE customer_trx_id = cv_customer_trx_id;
286:
287: l_credit_to_type VARCHAR2(15);
288: l_object_class VARCHAR2(15);

Line 295: l_trx_number AR_PAYMENT_SCHEDULES_ALL.TRX_NUMBER%TYPE;

291: l_trx_line_amt NUMBER;
292: l_invoice_line_id NUMBER;
293: l_error BOOLEAN;
294: l_process_setl_wf BOOLEAN;
295: l_trx_number AR_PAYMENT_SCHEDULES_ALL.TRX_NUMBER%TYPE;
296:
297: BEGIN
298: IF OZF_DEBUG_HIGH_ON THEN
299: OZF_Utility_PVT.debug_message(l_full_name||' : start');

Line 477: FROM ar_payment_schedules

473:
474: CURSOR csr_trx_balance(cv_customer_trx_id IN NUMBER) IS
475: SELECT SUM(amount_due_remaining),
476: invoice_currency_code
477: FROM ar_payment_schedules
478: WHERE customer_trx_id = cv_customer_trx_id
479: GROUP BY invoice_currency_code;
480:
481: CURSOR csr_chk_line_product(cv_claim_id IN NUMBER) IS