APPS.MSC_SELECT_ALL_FOR_RELEASE_PUB dependencies on MSC_PLANS

Line 214: from msc_plans

210: p_dest_org_id number;
211:
212: cursor plan_type_c is
213: select curr_plan_type
214: from msc_plans
215: where plan_id = p_plan_id;
216:
217: PROCEDURE reset_record IS
218: BEGIN

Line 260: msc_plans p

256:
257: CURSOR validate_repair_module IS
258: select i.repair_module
259: from msc_item_attributes i,
260: msc_plans p
261: where i.inventory_item_id = p_item_id
262: and i.sr_instance_id = p_inst_id
263: and i.simulation_set_id = p.item_simulation_set_id
264: and p.sr_instance_id = i.sr_instance_id