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_BALANCE_TYPES

Line 116: jurisdiction_lvl pay_balance_types.jurisdiction_level%type,

112: (dimension_type pay_balance_dimensions.dimension_type%type,
113: expiry_check_code pay_balance_dimensions.expiry_checking_code%type,
114: expiry_check_lvl pay_balance_dimensions.expiry_checking_level%type,
115: dimension_name pay_balance_dimensions.dimension_name%type,
116: jurisdiction_lvl pay_balance_types.jurisdiction_level%type,
117: balance_type_column pay_dimension_routes.balance_type_column%type,
118: decode_required pay_dimension_routes.decode_required%type,
119: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
120: dimension_lvl pay_balance_dimensions.dimension_level%type,

Line 122: balance_type_id pay_balance_types.balance_type_id%type,

118: decode_required pay_dimension_routes.decode_required%type,
119: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
120: dimension_lvl pay_balance_dimensions.dimension_level%type,
121: period_type pay_balance_dimensions.period_type%type,
122: balance_type_id pay_balance_types.balance_type_id%type,
123: dim_rou_rr_route_id pay_dimension_routes.route_id%type,
124: tu_needed boolean,
125: jc_needed boolean,
126: si_needed boolean,

Line 168: balance_type_id pay_balance_types.balance_type_id%type,

164: type t_int_bal_rec is record
165: (
166: defined_balance_id pay_defined_balances.defined_balance_id%type,
167: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
168: balance_type_id pay_balance_types.balance_type_id%type,
169: balance_found boolean,
170: balance_value number,
171: jurisdiction_level pay_balance_types.jurisdiction_level%type,
172: tax_unit_id pay_assignment_actions.tax_unit_id%type,

Line 171: jurisdiction_level pay_balance_types.jurisdiction_level%type,

167: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
168: balance_type_id pay_balance_types.balance_type_id%type,
169: balance_found boolean,
170: balance_value number,
171: jurisdiction_level pay_balance_types.jurisdiction_level%type,
172: tax_unit_id pay_assignment_actions.tax_unit_id%type,
173: jurisdiction_code pay_run_results.jurisdiction_code%type,
174: source_id number,
175: source_text pay_run_result_values.result_value%type,

Line 215: balance_type_id pay_balance_types.balance_type_id%type,

211: -- Batch retrieval cache.
212: --
213: type t_batch_rec is record
214: (
215: balance_type_id pay_balance_types.balance_type_id%type,
216: balance_value number,
217: source_index number -- This is used to index back to the
218: -- original PL/SQL table.
219: );

Line 847: , pay_balance_types TYP

843: g_defbal_cache(p_defined_balance_id).dimension_lvl,
844: g_defbal_cache(p_defined_balance_id).period_type
845: from pay_balance_dimensions DIM
846: , pay_defined_balances DEF
847: , pay_balance_types TYP
848: where DIM.balance_dimension_id = DEF.balance_dimension_id
849: and TYP.balance_type_id = DEF.balance_type_id
850: and DEF.defined_balance_id = p_defined_balance_id;
851: --

Line 3065: l_jur_lvl pay_balance_types.jurisdiction_level%type;

3061: l_balance_type_column pay_dimension_routes.balance_type_column%type;
3062: l_retrieval_column pay_dimension_routes.retrieval_column%type;
3063: l_decode_required boolean;
3064: l_decode_required_chr pay_dimension_routes.decode_required%type;
3065: l_jur_lvl pay_balance_types.jurisdiction_level%type;
3066: --
3067: BEGIN
3068: if g_debug then
3069: hr_utility.set_location('Entering pay_balance_pkg.get_run_bal', 10);

Line 3091: pay_balance_types pbt

3087: l_decode_required_chr,
3088: l_jur_lvl
3089: from pay_defined_balances pdb,
3090: pay_dimension_routes pdr,
3091: pay_balance_types pbt
3092: where pdb.defined_balance_id = p_def_bal_id
3093: and pdb.balance_dimension_id = pdr.balance_dimension_id
3094: and pbt.balance_type_id = pdb.balance_type_id
3095: and pdr.priority = p_priority;

Line 5317: l_jur_lvl pay_balance_types.jurisdiction_level%type;

5313: l_batch_list t_batch_list;
5314: l_batch_cnt number;
5315: l_dummy_value number;
5316: l_decode_required boolean;
5317: l_jur_lvl pay_balance_types.jurisdiction_level%type;
5318: --
5319: begin
5320: g_debug := hr_utility.debug_enabled;
5321: --

Line 8624: pay_balance_types pbt,

8620: pay_assignment_actions paa,
8621: pay_run_results prr,
8622: pay_input_values_f piv,
8623: pay_balance_feeds_f pbf,
8624: pay_balance_types pbt,
8625: pay_defined_balances pdb,
8626: pay_balance_dimensions pbd,
8627: pay_run_result_values prrv
8628: where pbd.dimension_level = 'GRP'

Line 9491: pay_balance_types pbt,

9487: from
9488: pay_run_results prr,
9489: pay_run_result_values prrv,
9490: pay_balance_feeds_f pbf,
9491: pay_balance_types pbt,
9492: pay_defined_balances pdb,
9493: pay_balance_dimensions pbd
9494: where pbd.dimension_level = 'ASG'
9495: and pdb.save_run_balance|| decode (pbt.balance_type_id, 0, '', '')= 'Y'

Line 11991: l_balance_type_id pay_balance_types.balance_type_id%type;

11987: function linked_defined_balance(p_defined_balance_id in number,
11988: p_business_group_id in number,
11989: p_balance_load_date in date)
11990: return number is
11991: l_balance_type_id pay_balance_types.balance_type_id%type;
11992: l_balance_dimension_id pay_defined_balances.balance_dimension_id%type;
11993: l_user_entity_name ff_user_entities.user_entity_name%type;
11994: l_linked_ue_name ff_user_entities.user_entity_name%type;
11995: l_ue_leg_code ff_user_entities.legislation_code%type;