APPS.ENG_CHANGE_LIFECYCLE_UTIL dependencies on DUAL

Line 2052: FROM DUAL

2048: --Bug No: 4767315
2049: --returns Y if there exists no revised items which are not cancelled for the CO
2050: CURSOR c_no_revisedItem IS
2051: SELECT 'Y'
2052: FROM DUAL
2053: WHERE not exists (SELECT 1
2054: FROM eng_revised_items
2055: WHERE change_id=p_change_id
2056: AND status_code <> 5

Line 3301: FROM DUAL;

3297: -- First get the new unique index id value for the new row (also save the old id)
3298: l_old_row_id := l_lcStatuses_row.change_lifecycle_status_id;
3299: SELECT eng_lifecycle_statuses_s.nextval
3300: INTO l_new_row_id
3301: FROM DUAL;
3302:
3303: -- Secondly get the new wf_route_id if needed
3304: IF (l_lcStatuses_row.change_wf_route_id IS NULL) THEN
3305: l_new_route_id := NULL;