4227: END;
4228:
4229: ELSIF p_mode = 3 THEN
4230: BEGIN
4231: select /*+ INDEX(msc_atp_summary_res MSC_ATP_SUMMARY_RES_U1) */ sd_qty
4232: into temp_sd_qty
4233: from msc_atp_summary_res
4234: where plan_id = p_plan_id
4235: and sr_instance_id = p_instance_id
4229: ELSIF p_mode = 3 THEN
4230: BEGIN
4231: select /*+ INDEX(msc_atp_summary_res MSC_ATP_SUMMARY_RES_U1) */ sd_qty
4232: into temp_sd_qty
4233: from msc_atp_summary_res
4234: where plan_id = p_plan_id
4235: and sr_instance_id = p_instance_id
4236: and organization_id = p_organization_id
4237: and resource_id = p_resource_id