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.22.12010000.2 2008/08/04 11:43:24 gnrajago 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 193: v_terms_id ap_invoices.terms_id%TYPE;

189: -- AP_SELECTED_INVOICES table. The variable v_invoice_id is to be
190: -- used in CURSOR c2_accept.
191: v_invoice_id ap_selected_invoices.invoice_id%TYPE;
192: v_invoice_num ap_selected_invoices.invoice_num%TYPE;
193: v_terms_id ap_invoices.terms_id%TYPE;
194: v_terms_date ap_invoices.terms_date%TYPE;
195: v_terms_type fv_terms_types.terms_type%TYPE;
196: v_po_distribution_id ap_invoice_distributions.po_distribution_id%TYPE;
197: v_transaction_type rcv_transactions.transaction_type%TYPE;

Line 194: v_terms_date ap_invoices.terms_date%TYPE;

190: -- used in CURSOR c2_accept.
191: v_invoice_id ap_selected_invoices.invoice_id%TYPE;
192: v_invoice_num ap_selected_invoices.invoice_num%TYPE;
193: v_terms_id ap_invoices.terms_id%TYPE;
194: v_terms_date ap_invoices.terms_date%TYPE;
195: v_terms_type fv_terms_types.terms_type%TYPE;
196: v_po_distribution_id ap_invoice_distributions.po_distribution_id%TYPE;
197: v_transaction_type rcv_transactions.transaction_type%TYPE;
198: v_po_line_location_id rcv_transactions.po_line_location_id%TYPE;

Line 255: v_goods_rec_date ap_invoices.goods_received_date%TYPE;

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