APPS.OZF_AR_VALIDATION_PVT dependencies on AR_PAYMENT_SCHEDULES

Line 181: FROM ar_payment_schedules

177: , trx_number
178: , amount_line_items_remaining
179: , tax_remaining
180: , freight_remaining
181: FROM ar_payment_schedules
182: WHERE customer_trx_id = cv_customer_trx_id;
183:
184:
185: l_payment_schedule_id NUMBER;

Line 299: SELECT trx_number from ar_payment_schedules_all

295: FROM ra_customer_trx_lines
296: WHERE customer_trx_line_id = cv_invoice_line_id;
297:
298: CURSOR csr_trx_details(cv_customer_trx_id IN NUMBER) IS
299: SELECT trx_number from ar_payment_schedules_all
300: WHERE customer_trx_id = cv_customer_trx_id;
301:
302: l_credit_to_type VARCHAR2(15);
303: l_object_class VARCHAR2(15);

Line 310: l_trx_number AR_PAYMENT_SCHEDULES_ALL.TRX_NUMBER%TYPE;

306: l_trx_line_amt NUMBER;
307: l_invoice_line_id NUMBER;
308: l_error BOOLEAN;
309: l_process_setl_wf BOOLEAN;
310: l_trx_number AR_PAYMENT_SCHEDULES_ALL.TRX_NUMBER%TYPE;
311:
312: BEGIN
313: IF OZF_DEBUG_HIGH_ON THEN
314: OZF_Utility_PVT.debug_message(l_full_name||' : start');

Line 492: FROM ar_payment_schedules

488:
489: CURSOR csr_trx_balance(cv_customer_trx_id IN NUMBER) IS
490: SELECT SUM(amount_due_remaining),
491: invoice_currency_code
492: FROM ar_payment_schedules
493: WHERE customer_trx_id = cv_customer_trx_id
494: GROUP BY invoice_currency_code;
495:
496: CURSOR csr_chk_line_product(cv_claim_id IN NUMBER) IS