APPS.FV_DUE_DATE_CALCULATION dependencies on FV_TERMS_TYPES

Line 26: fv_terms_types fvt,

22: FROM
23: ap_invoices api,
24: ap_terms apt,
25: ap_terms_lines apl,
26: fv_terms_types fvt,
27: --ap_invoice_distributions aid,
28: ap_payment_schedules aps
29: WHERE api.cancelled_amount IS NULL
30: AND api.invoice_type_lookup_code <> 'INTEREST'

Line 196: v_terms_type fv_terms_types.terms_type%TYPE;

192: v_invoice_id ap_selected_invoices.invoice_id%TYPE;
193: v_invoice_num ap_selected_invoices.invoice_num%TYPE;
194: v_terms_id ap_invoices.terms_id%TYPE;
195: v_terms_date ap_invoices.terms_date%TYPE;
196: v_terms_type fv_terms_types.terms_type%TYPE;
197: v_po_distribution_id ap_invoice_distributions.po_distribution_id%TYPE;
198: v_transaction_type rcv_transactions.transaction_type%TYPE;
199: v_po_line_location_id rcv_transactions.po_line_location_id%TYPE;
200: v_transaction_date rcv_transactions.transaction_date%TYPE;

Line 400: FROM fv_terms_types

396: SELECT constructive_acceptance_days,
397: invoice_return_days
398: INTO v_con_acc_days,
399: v_invoice_return_days
400: FROM fv_terms_types
401: WHERE term_id = v_terms_id;
402:
403: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cons acceptance days are :'||v_con_acc_days);
404: /* Calculating due date for invoice which has po distribution */