eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_BALANCE_PKG dependencies on PAY_DIMENSION_ROUTES

Line 69: balance_type_column pay_dimension_routes.balance_type_column%type,

65: expiry_check_code pay_balance_dimensions.expiry_checking_code%type,
66: expiry_check_lvl pay_balance_dimensions.expiry_checking_level%type,
67: dimension_name pay_balance_dimensions.dimension_name%type,
68: jurisdiction_lvl pay_balance_types.jurisdiction_level%type,
69: balance_type_column pay_dimension_routes.balance_type_column%type,
70: decode_required pay_dimension_routes.decode_required%type,
71: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
72: dimension_lvl pay_balance_dimensions.dimension_level%type,
73: period_type pay_balance_dimensions.period_type%type,

Line 70: decode_required pay_dimension_routes.decode_required%type,

66: expiry_check_lvl pay_balance_dimensions.expiry_checking_level%type,
67: dimension_name pay_balance_dimensions.dimension_name%type,
68: jurisdiction_lvl pay_balance_types.jurisdiction_level%type,
69: balance_type_column pay_dimension_routes.balance_type_column%type,
70: decode_required pay_dimension_routes.decode_required%type,
71: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
72: dimension_lvl pay_balance_dimensions.dimension_level%type,
73: period_type pay_balance_dimensions.period_type%type,
74: balance_type_id pay_balance_types.balance_type_id%type,

Line 75: dim_rou_rr_route_id pay_dimension_routes.route_id%type,

71: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
72: dimension_lvl pay_balance_dimensions.dimension_level%type,
73: period_type pay_balance_dimensions.period_type%type,
74: balance_type_id pay_balance_types.balance_type_id%type,
75: dim_rou_rr_route_id pay_dimension_routes.route_id%type,
76: tu_needed boolean,
77: jc_needed boolean,
78: si_needed boolean,
79: sn_needed boolean,

Line 103: priority pay_dimension_routes.priority%type,

99: --
100: type t_dim_rou_rec is record
101: (
102: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
103: priority pay_dimension_routes.priority%type,
104: route_type pay_dimension_routes.route_type%type,
105: run_def_bal_id pay_defined_balances.defined_balance_id%type,
106: retrieval_column pay_dimension_routes.retrieval_column%type
107: );

Line 104: route_type pay_dimension_routes.route_type%type,

100: type t_dim_rou_rec is record
101: (
102: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
103: priority pay_dimension_routes.priority%type,
104: route_type pay_dimension_routes.route_type%type,
105: run_def_bal_id pay_defined_balances.defined_balance_id%type,
106: retrieval_column pay_dimension_routes.retrieval_column%type
107: );
108: --

Line 106: retrieval_column pay_dimension_routes.retrieval_column%type

102: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
103: priority pay_dimension_routes.priority%type,
104: route_type pay_dimension_routes.route_type%type,
105: run_def_bal_id pay_defined_balances.defined_balance_id%type,
106: retrieval_column pay_dimension_routes.retrieval_column%type
107: );
108: --
109: type t_dim_rou_tab is table of t_dim_rou_rec index by binary_integer;
110: --

Line 703: from pay_dimension_routes pdr

699: , pdr.priority
700: , pdr.route_type
701: , null run_def_bal_id
702: , pdr.retrieval_column
703: from pay_dimension_routes pdr
704: , pay_defined_balances pdb -- balance defined balance
705: where pdb.balance_dimension_id = pdr.balance_dimension_id
706: and pdb.defined_balance_id = p_def_bal_id
707: and pdr.route_type = 'RR';

Line 716: from pay_dimension_routes pdr

712: , pdr.priority
713: , pdr.route_type
714: , rdb.defined_balance_id run_def_bal_id
715: , pdr.retrieval_column
716: from pay_dimension_routes pdr
717: , pay_defined_balances pdb -- balance defined balance
718: , pay_defined_balances rdb -- run defined balance
719: where pdb.balance_dimension_id = pdr.balance_dimension_id
720: and pdb.defined_balance_id = p_def_bal_id

Line 771: from pay_dimension_routes pdr

767: pdr.route_id
768: into g_defbal_cache(p_defined_balance_id).balance_type_column,
769: g_defbal_cache(p_defined_balance_id).decode_required,
770: g_defbal_cache(p_defined_balance_id).dim_rou_rr_route_id
771: from pay_dimension_routes pdr
772: , pay_defined_balances pdb
773: where pdb.balance_dimension_id = pdr.balance_dimension_id
774: and pdb.defined_balance_id = p_defined_balance_id
775: and pdr.route_type = 'RR';

Line 2784: l_route_id pay_dimension_routes.route_id%type;

2780: l_business_group_id ff_user_entities.business_group_id%type;
2781: l_legislation_code ff_user_entities.legislation_code%type;
2782: l_balance_list t_batch_list;
2783: l_balance_type_id pay_defined_balances.balance_type_id%type;
2784: l_route_id pay_dimension_routes.route_id%type;
2785: l_balance_type_column pay_dimension_routes.balance_type_column%type;
2786: l_retrieval_column pay_dimension_routes.retrieval_column%type;
2787: l_decode_required boolean;
2788: l_decode_required_chr pay_dimension_routes.decode_required%type;

Line 2785: l_balance_type_column pay_dimension_routes.balance_type_column%type;

2781: l_legislation_code ff_user_entities.legislation_code%type;
2782: l_balance_list t_batch_list;
2783: l_balance_type_id pay_defined_balances.balance_type_id%type;
2784: l_route_id pay_dimension_routes.route_id%type;
2785: l_balance_type_column pay_dimension_routes.balance_type_column%type;
2786: l_retrieval_column pay_dimension_routes.retrieval_column%type;
2787: l_decode_required boolean;
2788: l_decode_required_chr pay_dimension_routes.decode_required%type;
2789: l_jur_lvl pay_balance_types.jurisdiction_level%type;

Line 2786: l_retrieval_column pay_dimension_routes.retrieval_column%type;

2782: l_balance_list t_batch_list;
2783: l_balance_type_id pay_defined_balances.balance_type_id%type;
2784: l_route_id pay_dimension_routes.route_id%type;
2785: l_balance_type_column pay_dimension_routes.balance_type_column%type;
2786: l_retrieval_column pay_dimension_routes.retrieval_column%type;
2787: l_decode_required boolean;
2788: l_decode_required_chr pay_dimension_routes.decode_required%type;
2789: l_jur_lvl pay_balance_types.jurisdiction_level%type;
2790: --

Line 2788: l_decode_required_chr pay_dimension_routes.decode_required%type;

2784: l_route_id pay_dimension_routes.route_id%type;
2785: l_balance_type_column pay_dimension_routes.balance_type_column%type;
2786: l_retrieval_column pay_dimension_routes.retrieval_column%type;
2787: l_decode_required boolean;
2788: l_decode_required_chr pay_dimension_routes.decode_required%type;
2789: l_jur_lvl pay_balance_types.jurisdiction_level%type;
2790: --
2791: BEGIN
2792: if g_debug then

Line 2814: pay_dimension_routes pdr,

2810: l_retrieval_column,
2811: l_decode_required_chr,
2812: l_jur_lvl
2813: from pay_defined_balances pdb,
2814: pay_dimension_routes pdr,
2815: pay_balance_types pbt
2816: where pdb.defined_balance_id = p_def_bal_id
2817: and pdb.balance_dimension_id = pdr.balance_dimension_id
2818: and pbt.balance_type_id = pdb.balance_type_id

Line 3058: from pay_dimension_routes pdr

3054: select pdr.run_dimension_id
3055: , pdr.priority
3056: , pdr.route_type
3057: , rdb.defined_balance_id run_def_bal_id
3058: from pay_dimension_routes pdr
3059: , pay_defined_balances pdb -- balance defined balance
3060: , pay_defined_balances rdb -- run defined balance
3061: where pdb.balance_dimension_id = pdr.balance_dimension_id
3062: and pdb.defined_balance_id = p_def_bal_id