APPS.HR_LEGISLATION dependencies on FF_ROUTES

Line 790: ,ff_routes fr

786: SELECT distinct ao.key_name
787: ,ao.product_name
788: ,ao.key_value
789: FROM hr_s_application_ownerships ao
790: ,ff_routes fr
791: ,pay_balance_dimensions pbd
792: WHERE pbd.legislation_code ='ZZ'
793: AND ao.key_name = 'ROUTE_ID'
794: AND TO_NUMBER(ao.key_value) = fr.route_id

Line 2802: l_route_id ff_routes.route_id%type;

2798: ------------------------------------------------
2799: IS
2800: l_null_return varchar2(1); -- used for 'select null' statements
2801: l_new_surrogate_key number(15); -- new surrogate key for the delivery row
2802: l_route_id ff_routes.route_id%type;
2803:
2804: CURSOR stu -- selects all rows from startup entity
2805: IS
2806: select dimension_name c_true_key

Line 3152: from ff_routes

3148:
3149: BEGIN
3150: select null
3151: into l_null_return
3152: from ff_routes
3153: where route_id = stu_rec.route_id;
3154:
3155: return TRUE;
3156:

Line 3478: l_route_id ff_routes.route_id%type;

3474: , rowid
3475: from hr_s_dimension_routes;
3476:
3477: stu_rec stu%ROWTYPE; -- Record for the above select
3478: l_route_id ff_routes.route_id%type;
3479: l_run_dimension_id pay_dimension_routes.run_dimension_id%type;
3480:
3481: PROCEDURE remove IS
3482: -------------------

Line 3564: from ff_routes

3560: BEGIN
3561:
3562: select distinct null
3563: into l_null_return
3564: from ff_routes
3565: where route_id = stu_rec.route_id;
3566:
3567: EXCEPTION WHEN NO_DATA_FOUND THEN
3568: remove;