DBA Data[Home] [Help]

APPS.FV_CFS_PKG dependencies on FV_FUND_GROUPS

Line 3015: fv_fund_groups ffg

3011: INTO availability_type_treas,
3012: fund_type_treas ,
3013: exp_date
3014: FROM fv_treasury_symbols fts,
3015: fv_fund_groups ffg
3016: WHERE fts.treasury_symbol_id=get_ts_id_rec.treasury_symbol_id
3017: AND fts.set_of_books_id = v_sob
3018: AND fts.set_of_books_id = ffg.set_of_books_id
3019: AND ffg.fund_group_code = fts.fund_group_code;

Line 3021: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'After fv_treasury_symbols/fv_fund_groups');

3017: AND fts.set_of_books_id = v_sob
3018: AND fts.set_of_books_id = ffg.set_of_books_id
3019: AND ffg.fund_group_code = fts.fund_group_code;
3020:
3021: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'After fv_treasury_symbols/fv_fund_groups');
3022: -- Extract expiration date of treasury symbol and determine if the TS expired
3023: -- or will it expire in the year for which the process is run
3024: IF(exp_date < close_date ) THEN
3025: whether_Exp := 'E';