DBA Data[Home] [Help]

APPS.ENG_CHANGE_ORDER_TYPES_PKG dependencies on ENG_CHANGE_ROUTES_TL

Line 516: FROM eng_change_routes_tl a,

512: IF (phase_types(l_phase_id) = 8) -- approval status code
513: THEN
514: SELECT a.route_id
515: INTO l_route_id
516: FROM eng_change_routes_tl a,
517: eng_change_routes b
518: WHERE a.ROUTE_NAME = 'Standard Approval Process'
519: AND b.route_id = a.route_id
520: AND a.language = 'US'