APPS.FV_FUNDS_AVAIL_PKG dependencies on FV_FUND_PARAMETERS

Line 455: SELECT COUNT(1) INTO vl_fund FROM FV_FUND_PARAMETERS

451: RETURN ;
452: END IF;
453:
454: -- Verify If Fund values are exists for the Treasury Symbol user entered .
455: SELECT COUNT(1) INTO vl_fund FROM FV_FUND_PARAMETERS
456: WHERE TREASURY_SYMBOL_ID = vp_treasury_symbol_id
457: AND set_of_books_id = vp_sob_id ;
458: IF vl_fund=0 THEN
459: vp_retcode := -1 ;

Line 481: '(SELECT FUND_VALUE FROM FV_FUND_PARAMETERS

477: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' SELECT STATMENT WHEN PROCESS RUNS FOR TAS ' || VG_SELECT );
478: END IF;
479:
480: vg_where := 'glcc.'|| vg_bal_segment || ' IN ' ||
481: '(SELECT FUND_VALUE FROM FV_FUND_PARAMETERS
482: WHERE TREASURY_SYMBOL_ID = '||vp_treasury_symbol_id||
483: ' AND FV_FUND_PARAMETERS.set_of_books_id= '||vp_sob_id||')' ;
484:
485: Populate_CCIDs(vg_select,vg_where);

Line 483: ' AND FV_FUND_PARAMETERS.set_of_books_id= '||vp_sob_id||')' ;

479:
480: vg_where := 'glcc.'|| vg_bal_segment || ' IN ' ||
481: '(SELECT FUND_VALUE FROM FV_FUND_PARAMETERS
482: WHERE TREASURY_SYMBOL_ID = '||vp_treasury_symbol_id||
483: ' AND FV_FUND_PARAMETERS.set_of_books_id= '||vp_sob_id||')' ;
484:
485: Populate_CCIDs(vg_select,vg_where);
486: END IF ;
487: EXCEPTION