APPS.FV_PURGED_TREASURY_SYMBOLS dependencies on FV_FUND_PARAMETERS

Line 72: from Fv_fund_parameters

68: cursor c_fund_parameters(tres_id number, v_sob number) is
69: select fund_parameter_id,fund_value,
70: treasury_symbol,set_of_books_id,
71: fund_group_code
72: from Fv_fund_parameters
73: where treasury_symbol_id = tres_id
74: and set_of_books_id = v_sob;
75:
76: /*-----------------------------------------------------+

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 483: from Fv_fund_parameters

479: unliquid_obligations,
480: expended_amount,
481: red_status,
482: prior_year_recoveries
483: from Fv_fund_parameters
484: where treasury_symbol_id = tres_id
485: and set_of_books_id = gbl_set_of_books_id;
486: EXCEPTION
487: WHEN NO_DATA_FOUND THEN

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 811: delete from fv_fund_parameters ffp

807: l_module_name VARCHAR2(200):= 'DELETE_TREASURY_SYMBOLS';
808:
809: begin
810: BEGIN
811: delete from fv_fund_parameters ffp
812: where exists ( select treasury_symbol_id
813: from fv_treasury_symbols_history fts
814: where fts.set_of_books_id = gbl_set_of_books_id
815: and fts.treasury_symbol_id = ffp.treasury_symbol_id

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