APPS.PAY_IP_STARTUP_UTIL dependencies on FF_ROUTES

Line 675: FROM ff_routes a

671: CURSOR get_routes_csr IS
672: SELECT
673: route_id, route_name, user_defined_flag, description, text, last_update_date,
674: last_updated_by, last_update_login, created_by, creation_date
675: FROM ff_routes a
676: WHERE EXISTS (SELECT NULL
677: FROM pay_balance_dimensions c
678: WHERE c.route_id = a.route_id
679: AND c.legislation_code = 'ZZ');

Line 742: ,ff_routes fr

738: SELECT ao.key_name
739: ,ao.product_name
740: ,ao.key_value
741: FROM hr_application_ownerships ao
742: ,ff_routes fr
743: ,pay_balance_dimensions pbd
744: WHERE pbd.legislation_code ='ZZ'
745: AND ao.key_name = 'ROUTE_ID'
746: AND TO_NUMBER(ao.key_value) = fr.route_id