APPS.FV_AP_CASH_POS_DTL_PKG dependencies on AP_SELECTED_INVOICES

Line 19: g_checkrun_name ap_selected_invoices_all.checkrun_name%TYPE;

15: g_segment_value gl_code_combinations.segment1%TYPE;
16: g_error_code NUMBER(15);
17: g_error_buf VARCHAR2(500);
18: g_error_stage NUMBER(15);
19: g_checkrun_name ap_selected_invoices_all.checkrun_name%TYPE;
20: g_checkrun_id ap_selected_invoices_all.checkrun_id%TYPE;
21: g_apps_id NUMBER := 101;
22: g_flex_code VARCHAR2(25) ;
23: g_org_id NUMBER(15);

Line 20: g_checkrun_id ap_selected_invoices_all.checkrun_id%TYPE;

16: g_error_code NUMBER(15);
17: g_error_buf VARCHAR2(500);
18: g_error_stage NUMBER(15);
19: g_checkrun_name ap_selected_invoices_all.checkrun_name%TYPE;
20: g_checkrun_id ap_selected_invoices_all.checkrun_id%TYPE;
21: g_apps_id NUMBER := 101;
22: g_flex_code VARCHAR2(25) ;
23: g_org_id NUMBER(15);
24: Invalid_segment EXCEPTION;

Line 58: from ap_selected_invoices_all

54: g_org_id := p_org_id;
55: else
56: select org_id
57: into g_org_id
58: from ap_selected_invoices_all
59: where checkrun_id = g_checkrun_id
60: and rownum < 2;
61: end if;
62:

Line 199: FROM ap_selected_invoices_all asi

195:
196: --changed checkrun_name to checkrun_id
197: CURSOR invoice_count_cur(p_checkrun_id NUMBER) IS
198: SELECT count(asi.invoice_num||asi.vendor_id||asi.vendor_site_id) count
199: FROM ap_selected_invoices_all asi
200: WHERE asi.checkrun_id = p_checkrun_id;
201:
202: /*---------comments-----------------------------------------------
203: CURSOR bank_acct_cur(p_checkrun_id NUMBER) IS

Line 377: FROM ap_selected_invoices asi,

373: apd.dist_code_combination_id dist_code_combination_id,
374: ((asi.payment_amount) *(apd.amount/asi.invoice_amount)) amount,
375: asi.vendor_id,
376: asi.vendor_site_id
377: FROM ap_selected_invoices asi,
378: ap_invoice_distributions apd
379: WHERE asi.checkrun_id = p_checkrun_id
380: AND apd.invoice_id = asi.invoice_id
381: ORDER by asi.invoice_num;