DBA Data[Home] [Help]

APPS.FV_FUNDS_AVAIL_PKG dependencies on FV_FUNDS_AVAIL_REP_DEF

Line 571: FROM Fv_Funds_Avail_Rep_Def

567:
568: -- Check whether seed process was run
569:
570: SELECT COUNT(1) INTO vl_seed_count
571: FROM Fv_Funds_Avail_Rep_Def
572: WHERE set_of_books_id = vp_sob_id
573: AND Report_Id = vp_report_id ;
574:
575: IF vl_seed_count=0 THEN

Line 585: FROM Fv_Funds_Avail_Rep_Def fvd ,

581: -- Check whether Accounts are Defined in the form ,
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 ;

Line 636: ' FROM Fv_Funds_Avail_Rep_Def fvd ,

632: 'SELECT '||select_cl||
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 '||

Line 746: ' FROM Fv_Funds_Avail_Rep_Def fvd ,

742: 'SELECT '||select_cl||
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 '||