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 457: insert ALL into fv_fund_parameters_history

453: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,gbl_error_buf);
454: return;
455: END;
456: BEGIN
457: insert ALL into fv_fund_parameters_history
458: (fund_parameter_id,
459: fund_value,
460: treasury_symbol,
461: set_of_books_id,

Line 510: from Fv_fund_parameters

506: cust_non_cust,
507: NVL(auto_create,'N'),
508: auto_create_fund_value
509:
510: from Fv_fund_parameters
511: where treasury_symbol_id = tres_id
512: and set_of_books_id = gbl_set_of_books_id;
513: EXCEPTION
514: WHEN NO_DATA_FOUND THEN

Line 644: from fv_fund_parameters_history

640: and request_id = gbl_prelim_req_id;
641: ---and open_flag in('N');
642: /*cursor c2_fund_param_hist (tres_id number ) is
643: select fund_value
644: from fv_fund_parameters_history
645: where set_of_books_id = gbl_set_of_books_id
646: and treasury_symbol_id = tres_id;*/
647: BEGIN
648: --dbms_output.put_line('inside ins_delete_treasury_symbols');

Line 841: delete from fv_fund_parameters ffp

837: l_module_name VARCHAR2(200):= 'DELETE_TREASURY_SYMBOLS';
838:
839: begin
840: BEGIN
841: delete from fv_fund_parameters ffp
842: where exists ( select treasury_symbol_id
843: from fv_treasury_symbols_history fts
844: where fts.set_of_books_id = gbl_set_of_books_id
845: and fts.treasury_symbol_id = ffp.treasury_symbol_id

Line 900: delete from fv_fund_parameters_history ffp

896: l_module_name VARCHAR2(200):= 'CLEAN UP';
897: begin
898: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_statement, l_module_name,' inside clean up procedure');
899:
900: delete from fv_fund_parameters_history ffp
901: where ffp.set_of_books_id = gbl_set_of_books_id
902: and exists ( select treasury_symbol_id
903: from fv_treasury_symbols_history fts
904: where fts.set_of_books_id= gbl_set_of_books_id