APPS.ENG_CHANGE_ORDER_TYPES_PKG dependencies on ENG_LIFECYCLE_STATUSES_S

Line 154: SELECT eng_lifecycle_statuses_s.nextval

150:
151: BEGIN
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 (

Line 508: SELECT eng_lifecycle_statuses_s.nextval

504: LOOP
505: l_seq_no := l_seq_no +10;
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