DBA Data[Home] [Help]

APPS.XTR_EXP_SUMM_P dependencies on XTR_TMP_FX_EXPOSURE

Line 612: delete from XTR_tmp_fx_exposure

608: --
609: begin
610: delete from XTR_exposure_summary
611: where created_on < (trunc(sysdate) - 7);
612: delete from XTR_tmp_fx_exposure
613: where created_on < (trunc(sysdate) - 7);
614: --
615: commit;
616: --

Line 833: insert into XTR_TMP_FX_EXPOSURE

829: l_fx_amt := 0;
830: end if;
831: close GET_FX_POSTION;
832: --
833: insert into XTR_TMP_FX_EXPOSURE
834: (unique_ref_number,currency,period_name,period_desc,FX_PERCENT_MAX,FX_PERCENT_MIN,
835: exp_amount,fx_amount,created_on,created_by,incl_fx_options,incl_indic_exposures,
836: company,base_currency,selected_base_currency,selected_ccy,selected_portfolio,yield_curve,
837: period_from,period_to,net_exposure,cover_to_forecast,max_amount,min_amount)