582: -- Funds Availability Report Definitions .
583:
584: SELECT COUNT(1) INTO vl_Acct_count
585: FROM Fv_Funds_Avail_Rep_Def fvd ,
586: Fv_Funds_Avail_Acct_Ranges fvr
587: WHERE fvr.column_id=fvd.column_id
588: AND fvr.set_of_books_id = vp_sob_id
589: AND Report_Id = vp_report_id ;
590:
633: ' , fvd.report_id, '||
634: ' fvr.column_id , '||
635: vg_amount ||
636: ' FROM Fv_Funds_Avail_Rep_Def fvd ,
637: Fv_Funds_Avail_Acct_Ranges fvr,
638: Gl_Code_Combinations glcc , Gl_Balances glb
639: WHERE glcc.code_combination_id =
640: glb.code_combination_id '||
641: ' AND fvr.column_id=fvd.column_id '||
743: ' , fvd.report_id, '||
744: ' fvr.column_id , '||
745: vg_amount ||
746: ' FROM Fv_Funds_Avail_Rep_Def fvd ,
747: Fv_Funds_Avail_Acct_Ranges fvr,
748: Gl_Code_Combinations glcc , Gl_Bc_Packets glbc
749: WHERE glcc.code_combination_id =
750: glbc.code_combination_id '||
751: ' AND fvr.column_id=fvd.column_id '||