APPS.PAY_IP_BAL_UPLOAD dependencies on PAY_BALANCE_DIMENSIONS

Line 11: pay_balance_dimensions.dimension_name%type index by binary_integer;

7: --
8: -- Global variable type
9: --
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:

Line 47: pay_balance_dimensions pbd

43: select
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

Line 81: pay_balance_dimensions pbd

77: select
78: upper(pbd.dimension_name)
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

Line 368: FROM PAY_BALANCE_DIMENSIONS

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
370: AND upper(dimension_name) = upper(p_dimension_name)
371: AND business_group_id IS NULL);
372: ************/

Line 556: FROM PAY_BALANCE_DIMENSIONS

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
558: AND upper(dimension_name) = upper(l_dimension_name)
559: AND business_group_id IS NULL);
560: ********************/