APPS.FV_IPAC_DISBURSEMENT_PKG dependencies on FV_OPERATING_UNITS

Line 19: g_ia_paygroup fv_operating_units.payables_ia_paygroup%TYPE;

15: g_status_processed fv_ipac_import.record_status%TYPE;
16: g_status_error fv_ipac_import.record_status%TYPE;
17: g_status_other_error fv_ipac_import.record_status%TYPE;
18: g_status_ap_imported fv_ipac_import.record_status%TYPE;
19: g_ia_paygroup fv_operating_units.payables_ia_paygroup%TYPE;
20: g_enter VARCHAR2(10);
21: g_exit VARCHAR2(10);
22:
23: -- variables used by "Update FV_INTERAGENCY_FUNDS Table" process

Line 159: --* : fv_operating_units SELECT *--

155: --* : mo_utils.get_ledger_info *--
156: --* : fnd_date.canonical_to_date *--
157: --* Tables Used : ap_invoices SELECT *--
158: --* : po_vendors SELECT *--
159: --* : fv_operating_units SELECT *--
160: --* : fv_interagency_funds SELECT *--
161: --* Logic : *--
162: --****************************************************************************************--
163: PROCEDURE upd_ia_main

Line 189: FROM fv_operating_units

185: WHERE ai.vendor_id = pv.vendor_id
186: AND ai.invoice_num LIKE 'IPAC%'
187: AND ai.payment_method_lookup_code = 'CLEARING'
188: AND EXISTS (SELECT 'X'
189: FROM fv_operating_units
190: WHERE set_of_books_id = p_sob_id
191: AND default_alc = 'Y'
192: AND payables_ia_paygroup = ai.pay_group_lookup_code)
193: AND TO_DATE(ai.creation_date,'DD-MM-YYYY') BETWEEN

Line 4297: --* Tables Used : fv_operating_units SELECT *--

4293: --* : kick_off_exception_report *--
4294: --* : kick_off_ipac_auto_pmt_process *--
4295: --* : cleanup_current_failed_run *--
4296: --* : move_data_to_history *--
4297: --* Tables Used : fv_operating_units SELECT *--
4298: --* Logic : *--
4299: --****************************************************************************************--
4300: PROCEDURE main
4301: (

Line 4367: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from fv_operating_units');

4363: */
4364: IF (p_retcode = g_SUCCESS) THEN
4365: BEGIN
4366: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4367: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from fv_operating_units');
4368: END IF;
4369: SELECT payables_ia_paygroup
4370: INTO g_ia_paygroup
4371: FROM fv_operating_units

Line 4371: FROM fv_operating_units

4367: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from fv_operating_units');
4368: END IF;
4369: SELECT payables_ia_paygroup
4370: INTO g_ia_paygroup
4371: FROM fv_operating_units
4372: WHERE set_of_books_id = g_set_of_books_id;
4373: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4374: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'g_ia_paygroup = '||g_ia_paygroup);
4375: END IF;