DBA Data[Home] [Help]

APPS.OZF_AR_VALIDATION_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

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');