APPS.FV_DUE_DATE_CALCULATION dependencies on AP_INVOICES

Line 6: /* Select records from ap_invoices which is not of type

2: --$Header: FVXFODDB.pls 120.27.12020000.2 2013/02/13 14:33:36 snama ship $
3: g_module_name VARCHAR2(100);
4: v_sob NUMBER;
5:
6: /* Select records from ap_invoices which is not of type
7: interest */
8:
9: CURSOR c1_main_select IS
10: SELECT api.invoice_id,

Line 23: ap_invoices api,

19: aps.third_discount_date,
20: api.goods_received_date,
21: api.invoice_date
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,

Line 31: AND ap_invoices_pkg.get_approval_status(

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'
31: AND ap_invoices_pkg.get_approval_status(
32: api.invoice_id,
33: api.invoice_amount,
34: api.payment_status_flag,
35: api.invoice_type_lookup_code)='APPROVED'

Line 194: v_terms_id ap_invoices.terms_id%TYPE;

190: -- AP_SELECTED_INVOICES table. The variable v_invoice_id is to be
191: -- used in CURSOR c2_accept.
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;

Line 195: v_terms_date ap_invoices.terms_date%TYPE;

191: -- used in CURSOR c2_accept.
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;

Line 256: v_goods_rec_date ap_invoices.goods_received_date%TYPE;

252: v_new_second_disc_date date;
253: v_new_third_disc_date date;
254: v_2_disc_date_flag varchar2(1);
255: v_3_disc_date_flag varchar2(1);
256: v_goods_rec_date ap_invoices.goods_received_date%TYPE;
257: cnt NUMBER ;
258:
259: v_rcv_trans_count NUMBER;
260: TYPE v_ref_cur IS REF CURSOR ;