APPS.MSC_LAUNCH_PLAN_PK dependencies on MSC_PARAMETERS

Line 530: | Update msc_parameters with anchor date |

526: where plan_id = arg_plan_id;
527: */
528:
529: /*---------------------------------------+
530: | Update msc_parameters with anchor date |
531: +---------------------------------------*/
532: UPDATE msc_parameters
533: SET repetitive_anchor_date = TO_DATE(arg_anchor_date, 'YYYY/MM/DD HH24:MI:SS')
534: WHERE (organization_id,sr_instance_id) IN (select organization_id, sr_instance_id

Line 532: UPDATE msc_parameters

528:
529: /*---------------------------------------+
530: | Update msc_parameters with anchor date |
531: +---------------------------------------*/
532: UPDATE msc_parameters
533: SET repetitive_anchor_date = TO_DATE(arg_anchor_date, 'YYYY/MM/DD HH24:MI:SS')
534: WHERE (organization_id,sr_instance_id) IN (select organization_id, sr_instance_id
535: from msc_plan_organizations
536: Where plan_id = v_plan_id);