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 952: FROM DUAL

948: sysdate,
949: -1,
950: decode(length(l_sc1(i)), 7,null,substrb(l_sc1(i),1,length(l_sc1(i))-7)),
951: to_date(impl_date, 'YYYY/MM/DD HH24:MI')
952: FROM DUAL
953: WHERE NOT EXISTS
954: ( SELECT 'X'
955: FROM BOM_SMALL_IMPL_TEMP
956: WHERE LOWEST_ITEM_ID = l_lid1(i)

Line 1563: FROM DUAL

1559: sysdate,
1560: -1,
1561: decode(length(l_sc1(i)), 7,null,substrb(l_sc1(i),1,length(l_sc1(i))-7)),
1562: to_date(impl_date, 'YYYY/MM/DD HH24:MI')
1563: FROM DUAL
1564: WHERE NOT EXISTS
1565: ( SELECT 'X'
1566: FROM BOM_SMALL_IMPL_TEMP
1567: WHERE LOWEST_ITEM_ID = l_lid1(i)