APPS.MSC_IMPORT_UTIL dependencies on MSC_PLANS

Line 729: msc_plans mp

725:
726: cursor c_sim_set(l_plan_id number) is
727: select simulation_set_name from
728: msc_item_simulation_sets ms,
729: msc_plans mp
730: where mp.plan_id=l_plan_id and ms.simulation_set_id = mp.item_simulation_set_id;
731:
732: l_sim_set varchar2(80);
733: begin

Line 767: update msc_plans set item_simulation_set_id = l_simset_id where plan_id=p_plan_id;

763: commit;
764: end if;
765:
766: if sim_set(p_plan_id) is null or sim_set(p_plan_id)<>p_simset then
767: update msc_plans set item_simulation_set_id = l_simset_id where plan_id=p_plan_id;
768: end if;
769:
770: commit;
771:

Line 801: from msc_plans

797: p_inst_id number) is
798:
799: cursor c_simset_id is
800: select item_simulation_set_id
801: from msc_plans
802: where plan_id = p_plan_id;
803:
804: cursor c_dest_rowid(p_simset_id number) is
805: select rowid