DBA Data[Home] [Help]

APPS.OZF_AR_VALIDATION_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

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