DBA Data[Home] [Help]

APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on MSC_APPS_INSTANCES

Line 3082: from msc_apps_instances

3078: 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
3079:
3080: cursor get_no_iv_org is
3081: select instance_code
3082: from msc_apps_instances
3083: where validation_org_id is null;
3084:
3085: cursor get_iv_org is
3086: select to_char(instance_id), to_char(validation_org_id) sr_level_pk

Line 3087: from msc_apps_instances

3083: where validation_org_id is null;
3084:
3085: cursor get_iv_org is
3086: select to_char(instance_id), to_char(validation_org_id) sr_level_pk
3087: from msc_apps_instances
3088: minus
3089: select instance, sr_level_pk
3090: from msd_level_values_ds
3091: where demand_plan_id = p_demand_plan_id