DBA Data[Home] [Help]

APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on MSC_APPS_INSTANCES

Line 3215: from msc_apps_instances

3211: Procedure chk_iv_org (p_demand_plan_id in number, p_iv_flag in varchar2, p_stripe_stream_name in varchar2, p_stripe_sr_level_pk in varchar2) is
3212:
3213: cursor get_no_iv_org is
3214: select instance_code
3215: from msc_apps_instances
3216: where validation_org_id is null;
3217:
3218: cursor get_iv_org is
3219: select to_char(instance_id), to_char(validation_org_id) sr_level_pk

Line 3220: from msc_apps_instances

3216: where validation_org_id is null;
3217:
3218: cursor get_iv_org is
3219: select to_char(instance_id), to_char(validation_org_id) sr_level_pk
3220: from msc_apps_instances
3221: minus
3222: select instance, sr_level_pk
3223: from msd_level_values_ds
3224: where demand_plan_id = p_demand_plan_id