APPS.BOMPIINQ dependencies on DUAL

Line 228: FROM DUAL

224: -1,
225: sysdate,
226: -1,
227: to_date(impl_date, 'YYYY/MM/DD HH24:MI')
228: FROM DUAL
229: WHERE NOT EXISTS
230: ( SELECT 'X'
231: FROM BOM_SMALL_IMPL_TEMP
232: WHERE SEQUENCE_ID = sequence_id

Line 937: FROM DUAL

933: sysdate,
934: -1,
935: decode(length(l_sc1(i)), 7,null,substrb(l_sc1(i),1,length(l_sc1(i))-7)),
936: to_date(impl_date, 'YYYY/MM/DD HH24:MI')
937: FROM DUAL
938: WHERE NOT EXISTS
939: ( SELECT 'X'
940: FROM BOM_SMALL_IMPL_TEMP
941: WHERE LOWEST_ITEM_ID = l_lid1(i)

Line 1534: FROM DUAL

1530: sysdate,
1531: -1,
1532: decode(length(l_sc1(i)), 7,null,substrb(l_sc1(i),1,length(l_sc1(i))-7)),
1533: to_date(impl_date, 'YYYY/MM/DD HH24:MI')
1534: FROM DUAL
1535: WHERE NOT EXISTS
1536: ( SELECT 'X'
1537: FROM BOM_SMALL_IMPL_TEMP
1538: WHERE LOWEST_ITEM_ID = l_lid1(i)