APPS.ENG_CHANGE_LIFECYCLE_UTIL dependencies on ENG_CHANGE_ROUTES

Line 1284: FROM eng_change_routes route,

1280: )
1281: IS
1282: SELECT DISTINCT route.route_id wf_route_id
1283: , line.change_line_id
1284: FROM eng_change_routes route,
1285: eng_change_statuses s,
1286: eng_change_lines line,
1287: eng_lifecycle_statuses line_start_after,
1288: eng_lifecycle_statuses new_status,

Line 1980: FROM eng_change_routes route,

1976: l.complete_before_status_code,
1977: l.required_flag,
1978: l.change_type_id ,
1979: route.status_code wf_status_code
1980: FROM eng_change_routes route,
1981: eng_change_statuses s,
1982: eng_change_lines l
1983: WHERE s.status_code = l.status_code
1984: AND route.route_id(+) = l.route_id

Line 1991: l_wf_status_code eng_change_routes.status_code%TYPE;

1987: l_line_status_type eng_change_statuses.status_type%TYPE;
1988: l_status_code eng_change_lines.complete_before_status_code%TYPE;
1989: l_required_flag eng_change_lines.required_flag%TYPE := NULL;
1990: l_change_type_id NUMBER ;
1991: l_wf_status_code eng_change_routes.status_code%TYPE;
1992:
1993: -- Select all revised items
1994: CURSOR c_revItems IS
1995: SELECT status_code