APPS.ENG_CHANGE_ORDER_TYPES_PKG dependencies on DUAL

Line 149: FROM dual;

145: FOR cl in lifecycles
146: LOOP
147: SELECT eng_lifecycle_statuses_s.nextval
148: INTO l_lifecycle_phase_id
149: FROM dual;
150:
151: ENG_LC_STATUSES_INSERT (
152: X_ROWID =>v_row_id ,
153: X_CHANGE_LIFECYCLE_STATUS_ID =>l_lifecycle_phase_id ,

Line 473: FROM dual;

469: l_route_id := null;
470:
471: SELECT eng_lifecycle_statuses_s.nextval
472: INTO l_lifecycle_phase_id
473: FROM dual;
474:
475: IF (phase_types(l_phase_id) = 8) -- approval status code
476: THEN
477: SELECT a.route_id

Line 664: FROM dual;

660:
661: BEGIN
662: SELECT eng_change_order_types_s.nextval
663: INTO l_change_order_type_id
664: FROM dual;
665:
666: SELECT default_assignee_id,
667: subject_id,
668: default_assignee_type,