495: where plan_id = arg_plan_id;
496: */
497:
498: /*---------------------------------------+
499: | Update msc_parameters with anchor date |
500: +---------------------------------------*/
501: UPDATE msc_parameters
502: SET repetitive_anchor_date = TO_DATE(arg_anchor_date, 'YYYY/MM/DD HH24:MI:SS')
503: WHERE (organization_id,sr_instance_id) IN (select organization_id, sr_instance_id
497:
498: /*---------------------------------------+
499: | Update msc_parameters with anchor date |
500: +---------------------------------------*/
501: UPDATE msc_parameters
502: SET repetitive_anchor_date = TO_DATE(arg_anchor_date, 'YYYY/MM/DD HH24:MI:SS')
503: WHERE (organization_id,sr_instance_id) IN (select organization_id, sr_instance_id
504: from msc_plan_organizations
505: Where plan_id = v_plan_id);