APPS.ENG_CHANGE_ORDER_TYPES_PKG dependencies on DUAL

Line 156: FROM dual;

152: FOR cl in lifecycles
153: LOOP
154: SELECT eng_lifecycle_statuses_s.nextval
155: INTO l_lifecycle_phase_id
156: FROM dual;
157:
158: ENG_LC_STATUSES_INSERT (
159: X_ROWID =>v_row_id ,
160: X_CHANGE_LIFECYCLE_STATUS_ID =>l_lifecycle_phase_id ,

Line 510: FROM dual;

506: l_route_id := null;
507:
508: SELECT eng_lifecycle_statuses_s.nextval
509: INTO l_lifecycle_phase_id
510: FROM dual;
511:
512: IF (phase_types(l_phase_id) = 8) -- approval status code
513: THEN
514: SELECT a.route_id

Line 701: FROM dual;

697:
698: BEGIN
699: SELECT eng_change_order_types_s.nextval
700: INTO l_change_order_type_id
701: FROM dual;
702:
703: SELECT default_assignee_id,
704: subject_id,
705: default_assignee_type,