APPS.PAY_IP_BAL_UPLOAD dependencies on FF_ROUTES

Line 14: ff_routes.route_name%type index by binary_integer;

10: type t_dimension_names_tab is table of
11: pay_balance_dimensions.dimension_name%type index by binary_integer;
12:
13: type t_route_names_tab is table of
14: ff_routes.route_name%type index by binary_integer;
15:
16: --
17: -- Cache for expiry date
18: --

Line 48: ,ff_routes r

44: upper(pbd.dimension_name)
45: ,r.route_name
46: from
47: pay_balance_dimensions pbd
48: ,ff_routes r
49: where
50: pbd.legislation_code = p_legislation_code
51: and pbd.route_id = r.route_id
52: and r.route_name in

Line 83: ,ff_routes r

79: ,r.route_name
80: from
81: pay_balance_dimensions pbd
82: ,pay_dimension_routes pdr
83: ,ff_routes r
84: where
85: pbd.legislation_code = p_legislation_code
86: and pbd.balance_dimension_id = pdr.balance_dimension_id
87: and pdr.route_id = r.route_id

Line 288: l_route_name ff_routes.route_name%type;

284: FUNCTION international_payroll
285: (p_dimension_name IN VARCHAR2,
286: p_legislation_code IN VARCHAR2) RETURN BOOLEAN IS
287: l_idx binary_integer;
288: l_route_name ff_routes.route_name%type;
289: BEGIN
290: hr_utility.trace('Entering pay_ip_bal_upload.international_payroll');
291:
292: --

Line 365: FROM ff_routes

361: CURSOR csr_route_name
362: (p_legislation_code VARCHAR2,
363: p_dimension_name VARCHAR2) IS
364: SELECT route_name
365: FROM ff_routes
366: WHERE route_id =
367: (SELECT route_id
368: FROM PAY_BALANCE_DIMENSIONS
369: WHERE legislation_code= p_legislation_code

Line 390: l_route_name FF_ROUTES.ROUTE_NAME%TYPE;

386: or (pee.original_entry_id = p_original_entry_id));
387:
388: l_expiry_date DATE;
389: l_business_group_id PER_ALL_ASSIGNMENTS_F.BUSINESS_GROUP_ID%TYPE;
390: l_route_name FF_ROUTES.ROUTE_NAME%TYPE;
391: l_itd_start_date date;
392: l_oe_start_date date;
393: BEGIN
394:

Line 553: FROM ff_routes

549: * This is replaced by get_dim_route_name().
550: *
551: CURSOR csr_route_name (l_legislation_code VARCHAR2, l_dimension_name VARCHAR2) IS
552: SELECT route_name
553: FROM ff_routes
554: WHERE route_id =
555: (SELECT route_id
556: FROM PAY_BALANCE_DIMENSIONS
557: WHERE legislation_code= l_legislation_code

Line 562: l_route_name FF_ROUTES.ROUTE_NAME%TYPE;

558: AND upper(dimension_name) = upper(l_dimension_name)
559: AND business_group_id IS NULL);
560: ********************/
561:
562: l_route_name FF_ROUTES.ROUTE_NAME%TYPE;
563: BEGIN
564:
565: hr_utility.trace('Entering pay_ip_bal_upload.include_adjustment');
566: