APPS.HR_LEGISLATION dependencies on FF_ROUTES

Line 585: ,ff_routes fr

581: SELECT distinct ao.key_name
582: ,ao.product_name
583: ,ao.key_value
584: FROM hr_s_application_ownerships ao
585: ,ff_routes fr
586: ,pay_balance_dimensions pbd
587: WHERE pbd.legislation_code ='ZZ'
588: AND ao.key_name = 'ROUTE_ID'
589: AND TO_NUMBER(ao.key_value) = fr.route_id

Line 2556: l_route_id ff_routes.route_id%type;

2552: ------------------------------------------------
2553: IS
2554: l_null_return varchar2(1); -- used for 'select null' statements
2555: l_new_surrogate_key number(15); -- new surrogate key for the delivery row
2556: l_route_id ff_routes.route_id%type;
2557:
2558: CURSOR stu -- selects all rows from startup entity
2559: IS
2560: select dimension_name c_true_key

Line 2906: from ff_routes

2902:
2903: BEGIN
2904: select null
2905: into l_null_return
2906: from ff_routes
2907: where route_id = stu_rec.route_id;
2908:
2909: return TRUE;
2910:

Line 3232: l_route_id ff_routes.route_id%type;

3228: , rowid
3229: from hr_s_dimension_routes;
3230:
3231: stu_rec stu%ROWTYPE; -- Record for the above select
3232: l_route_id ff_routes.route_id%type;
3233: l_run_dimension_id pay_dimension_routes.run_dimension_id%type;
3234:
3235: PROCEDURE remove IS
3236: -------------------

Line 3318: from ff_routes

3314: BEGIN
3315:
3316: select distinct null
3317: into l_null_return
3318: from ff_routes
3319: where route_id = stu_rec.route_id;
3320:
3321: EXCEPTION WHEN NO_DATA_FOUND THEN
3322: remove;