[Home] [Help]
1422: End if;
1423:
1424: SELECT COUNT(*)
1425: INTO l_cnt
1426: FROM fv_report_definitions
1427: WHERE set_of_books_id = p_set_of_books_id
1428: AND agency_location_code IS NULL
1429: AND d_r_flag IN ('D','R');
1430:
1865: FROM gl_je_batches glb,
1866: gl_je_headers glh,
1867: gl_je_lines gll,
1868: gl_code_combinations gcc,
1869: fv_report_definitions frd,
1870: fv_fund_parameters ffp,
1871: fv_treasury_symbols fts
1872: WHERE glb.status = ''P''
1873: AND glb.actual_flag = ''A''
1951: FROM gl_je_batches glb,
1952: gl_je_headers glh,
1953: gl_je_lines gll,
1954: gl_code_combinations gcc,
1955: fv_report_definitions frd,
1956: fv_fund_parameters ffp,
1957: fv_treasury_symbols fts,
1958: ap_invoices_all ai,
1959: ap_invoice_distributions_all aid,
2064: FROM gl_je_batches glb,
2065: gl_je_headers glh,
2066: gl_je_lines gll,
2067: gl_code_combinations gcc,
2068: fv_report_definitions frd,
2069: fv_fund_parameters ffp,
2070: fv_treasury_symbols fts,
2071: ap_invoices_all ai,
2072: ap_invoice_distributions_all aid,
2174: FROM gl_je_batches glb,
2175: gl_je_headers glh,
2176: gl_je_lines gll,
2177: gl_code_combinations gcc,
2178: fv_report_definitions frd,
2179: fv_fund_parameters ffp,
2180: fv_treasury_symbols fts,
2181: ap_invoice_distributions_all aid,
2182: ap_invoice_payments_all aip,
2286: FROM gl_je_batches glb,
2287: gl_je_headers glh,
2288: gl_je_lines gll,
2289: gl_code_combinations gcc,
2290: fv_report_definitions frd,
2291: fv_fund_parameters ffp,
2292: fv_treasury_symbols fts,
2293: gl_import_references glir,
2294: xla_ae_headers xah,
2393: FROM gl_je_batches glb,
2394: gl_je_headers glh,
2395: gl_je_lines gll,
2396: gl_code_combinations gcc,
2397: fv_report_definitions frd,
2398: fv_fund_parameters ffp,
2399: fv_treasury_symbols fts,
2400: ar_distributions_all ard,
2401: ar_cash_receipt_history_all arch,
2505: FROM gl_je_batches glb,
2506: gl_je_headers glh,
2507: gl_je_lines gll,
2508: gl_code_combinations gcc,
2509: fv_report_definitions frd,
2510: fv_fund_parameters ffp,
2511: fv_treasury_symbols fts,
2512: ar_distributions_all ard,
2513: AR_RECEIVABLE_APPLICATIONS_ALL arr,
2618: FROM gl_je_batches glb,
2619: gl_je_headers glh,
2620: gl_je_lines gll,
2621: gl_code_combinations gcc,
2622: fv_report_definitions frd,
2623: fv_fund_parameters ffp,
2624: fv_treasury_symbols fts,
2625: ar_distributions_all ard,
2626: AR_MISC_CASH_DISTRIBUTIONS_ALL arm,
2718:
2719: vg_bank_acct_id ce_bank_accounts.bank_account_id%TYPE;
2720: l_temp_cr_hist_id NUMBER;
2721: l_cash_receipt_hist_id NUMBER;
2722: l_federal_rpt_id Fv_Report_Definitions.federal_rpt_id%TYPE;
2723: l_rowid VARCHAR2(25);
2724: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
2725: l_INVOICE_ID AP_INVOICES.invoice_ID%TYPE;
2726: l_inv_amount NUMBER;
2942: -- Determine the default alc
2943: BEGIN
2944: SELECT agency_location_code
2945: INTO p_def_alc_code
2946: FROM Fv_Report_Definitions
2947: WHERE federal_rpt_id = l_federal_rpt_id;
2948: EXCEPTION
2949: WHEN NO_DATA_FOUND THEN
2950: error_buf := 'The default agency_location_code could not be determined