APPS.MSC_RP_RELEASE_PUB dependencies on DUAL

Line 109: select 1 from dual

105: -- md.last_updated_by)
106: -- and md.status = 0
107: -- and md.applied =2;
108:
109: select 1 from dual
110: where exists ( SELECT /*+ first_rows */ 1
111: FROM msc_demands md
112: where md.plan_id = p_plan_id
113: and md.release_errors is null

Line 584: FROM dual;

580:
581: --- get the unique number identifying the current session
582: SELECT MRP.mrp_atp_schedule_temp_s.nextval
583: INTO l_session_id
584: FROM dual;
585:
586: -- Call ATP method to get the intransit lead time value in
587: -- the out parameter x_intransit_lead_time
588: MSC_ATP_PROC.ATP_Intransit_LT(