APPS.ENG_CHANGE_ORDER_TYPES_PKG dependencies on ENG_LIFECYCLE_STATUSES_S

Line 147: SELECT eng_lifecycle_statuses_s.nextval

143: AND ENTITY_ID1 = X_PARENT_CHANGE_TYPE_ID;
144: BEGIN
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 (

Line 471: SELECT eng_lifecycle_statuses_s.nextval

467: LOOP
468: l_seq_no := l_seq_no +10;
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