DBA Data[Home] [Help]

APPS.ENG_CHANGE_ORDER_TYPES_PKG dependencies on ENG_CHANGE_ROUTES

Line 479: FROM eng_change_routes_tl a,

475: IF (phase_types(l_phase_id) = 8) -- approval status code
476: THEN
477: SELECT a.route_id
478: INTO l_route_id
479: FROM eng_change_routes_tl a,
480: eng_change_routes b
481: WHERE a.ROUTE_NAME = 'Standard Approval Process'
482: AND b.route_id = a.route_id
483: AND a.language = 'US'

Line 480: eng_change_routes b

476: THEN
477: SELECT a.route_id
478: INTO l_route_id
479: FROM eng_change_routes_tl a,
480: eng_change_routes b
481: WHERE a.ROUTE_NAME = 'Standard Approval Process'
482: AND b.route_id = a.route_id
483: AND a.language = 'US'
484: AND b.TEMPLATE_FLAG = 'Y';