APPS.FV_PURGED_TREASURY_SYMBOLS dependencies on FV_FUND_PARAMETERS_HISTORY

Line 440: insert ALL into fv_fund_parameters_history

436: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,gbl_error_buf);
437: return;
438: END;
439: BEGIN
440: insert ALL into fv_fund_parameters_history
441: (fund_parameter_id,
442: fund_value,
443: treasury_symbol,
444: set_of_books_id,

Line 617: from fv_fund_parameters_history

613: and request_id = gbl_prelim_req_id;
614: ---and open_flag in('N');
615: /*cursor c2_fund_param_hist (tres_id number ) is
616: select fund_value
617: from fv_fund_parameters_history
618: where set_of_books_id = gbl_set_of_books_id
619: and treasury_symbol_id = tres_id;*/
620: BEGIN
621: --dbms_output.put_line('inside ins_delete_treasury_symbols');

Line 870: delete from fv_fund_parameters_history ffp

866: l_module_name VARCHAR2(200):= 'CLEAN UP';
867: begin
868: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_statement, l_module_name,' inside clean up procedure');
869:
870: delete from fv_fund_parameters_history ffp
871: where ffp.set_of_books_id = gbl_set_of_books_id
872: and exists ( select treasury_symbol_id
873: from fv_treasury_symbols_history fts
874: where fts.set_of_books_id= gbl_set_of_books_id