[Home] [Help]
1443: End if;
1444:
1445: SELECT COUNT(*)
1446: INTO l_cnt
1447: FROM fv_report_definitions
1448: WHERE set_of_books_id = p_set_of_books_id
1449: AND agency_location_code IS NULL
1450: AND d_r_flag IN ('D','R');
1451:
1890: FROM gl_je_batches glb,
1891: gl_je_headers glh,
1892: gl_je_lines gll,
1893: gl_code_combinations gcc,
1894: fv_report_definitions frd,
1895: fv_fund_parameters ffp,
1896: fv_treasury_symbols fts
1897: WHERE glb.status = ''P''
1898: AND glb.actual_flag = ''A''
1977: FROM gl_je_batches glb,
1978: gl_je_headers glh,
1979: gl_je_lines gll,
1980: gl_code_combinations gcc,
1981: fv_report_definitions frd,
1982: fv_fund_parameters ffp,
1983: fv_treasury_symbols fts,
1984: ap_invoices_all ai,
1985: ap_invoice_distributions_all aid,
2091: FROM gl_je_batches glb,
2092: gl_je_headers glh,
2093: gl_je_lines gll,
2094: gl_code_combinations gcc,
2095: fv_report_definitions frd,
2096: fv_fund_parameters ffp,
2097: fv_treasury_symbols fts,
2098: ap_invoices_all ai,
2099: ap_invoice_distributions_all aid,
2183: FROM gl_je_batches glb,
2184: gl_je_headers glh,
2185: gl_je_lines gll,
2186: gl_code_combinations gcc,
2187: fv_report_definitions frd,
2188: fv_fund_parameters ffp,
2189: fv_treasury_symbols fts,
2190: ap_invoices_all ai,
2191: ap_invoice_distributions_all aid,
2297: FROM gl_je_batches glb,
2298: gl_je_headers glh,
2299: gl_je_lines gll,
2300: gl_code_combinations gcc,
2301: fv_report_definitions frd,
2302: fv_fund_parameters ffp,
2303: fv_treasury_symbols fts,
2304: ap_invoice_distributions_all aid,
2305: ap_invoice_payments_all aip,
2410: FROM gl_je_batches glb,
2411: gl_je_headers glh,
2412: gl_je_lines gll,
2413: gl_code_combinations gcc,
2414: fv_report_definitions frd,
2415: fv_fund_parameters ffp,
2416: fv_treasury_symbols fts,
2417: gl_import_references glir,
2418: xla_ae_headers xah,
2518: FROM gl_je_batches glb,
2519: gl_je_headers glh,
2520: gl_je_lines gll,
2521: gl_code_combinations gcc,
2522: fv_report_definitions frd,
2523: fv_fund_parameters ffp,
2524: fv_treasury_symbols fts,
2525: ar_distributions_all ard,
2526: ar_cash_receipt_history_all arch,
2631: FROM gl_je_batches glb,
2632: gl_je_headers glh,
2633: gl_je_lines gll,
2634: gl_code_combinations gcc,
2635: fv_report_definitions frd,
2636: fv_fund_parameters ffp,
2637: fv_treasury_symbols fts,
2638: ar_distributions_all ard,
2639: AR_RECEIVABLE_APPLICATIONS_ALL arr,
2745: FROM gl_je_batches glb,
2746: gl_je_headers glh,
2747: gl_je_lines gll,
2748: gl_code_combinations gcc,
2749: fv_report_definitions frd,
2750: fv_fund_parameters ffp,
2751: fv_treasury_symbols fts,
2752: ar_distributions_all ard,
2753: AR_MISC_CASH_DISTRIBUTIONS_ALL arm,
2846:
2847: vg_bank_acct_id ce_bank_accounts.bank_account_id%TYPE;
2848: l_temp_cr_hist_id NUMBER;
2849: l_cash_receipt_hist_id NUMBER;
2850: l_federal_rpt_id Fv_Report_Definitions.federal_rpt_id%TYPE;
2851: l_rowid VARCHAR2(25);
2852: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
2853: l_INVOICE_ID AP_INVOICES.invoice_ID%TYPE;
2854: l_inv_amount NUMBER;
3070: -- Determine the default alc
3071: BEGIN
3072: SELECT agency_location_code
3073: INTO p_def_alc_code
3074: FROM Fv_Report_Definitions
3075: WHERE federal_rpt_id = l_federal_rpt_id;
3076: EXCEPTION
3077: WHEN NO_DATA_FOUND THEN
3078: error_buf := 'The default agency_location_code could not be determined