APPS.PAY_BALANCE_PKG dependencies on PAY_BALANCE_TYPES

Line 68: jurisdiction_lvl pay_balance_types.jurisdiction_level%type,

64: (dimension_type pay_balance_dimensions.dimension_type%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,

Line 74: balance_type_id pay_balance_types.balance_type_id%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,
75: dim_rou_rr_route_id pay_dimension_routes.route_id%type,
76: tu_needed boolean,
77: jc_needed boolean,
78: si_needed boolean,

Line 120: balance_type_id pay_balance_types.balance_type_id%type,

116: type t_int_bal_rec is record
117: (
118: defined_balance_id pay_defined_balances.defined_balance_id%type,
119: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
120: balance_type_id pay_balance_types.balance_type_id%type,
121: balance_found boolean,
122: balance_value number,
123: jurisdiction_level pay_balance_types.jurisdiction_level%type,
124: tax_unit_id pay_assignment_actions.tax_unit_id%type,

Line 123: jurisdiction_level pay_balance_types.jurisdiction_level%type,

119: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
120: balance_type_id pay_balance_types.balance_type_id%type,
121: balance_found boolean,
122: balance_value number,
123: jurisdiction_level pay_balance_types.jurisdiction_level%type,
124: tax_unit_id pay_assignment_actions.tax_unit_id%type,
125: jurisdiction_code pay_run_results.jurisdiction_code%type,
126: source_id number,
127: source_text pay_run_result_values.result_value%type,

Line 167: balance_type_id pay_balance_types.balance_type_id%type,

163: -- Batch retrieval cache.
164: --
165: type t_batch_rec is record
166: (
167: balance_type_id pay_balance_types.balance_type_id%type,
168: balance_value number,
169: source_index number -- This is used to index back to the
170: -- original PL/SQL table.
171: );

Line 757: , pay_balance_types TYP

753: g_defbal_cache(p_defined_balance_id).dimension_lvl,
754: g_defbal_cache(p_defined_balance_id).period_type
755: from pay_balance_dimensions DIM
756: , pay_defined_balances DEF
757: , pay_balance_types TYP
758: where DIM.balance_dimension_id = DEF.balance_dimension_id
759: and TYP.balance_type_id = DEF.balance_type_id
760: and DEF.defined_balance_id = p_defined_balance_id;
761: --

Line 2789: l_jur_lvl pay_balance_types.jurisdiction_level%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
2793: hr_utility.set_location('Entering pay_balance_pkg.get_run_bal', 10);

Line 2815: pay_balance_types pbt

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
2819: and pdr.priority = p_priority;

Line 5015: l_jur_lvl pay_balance_types.jurisdiction_level%type;

5011: l_batch_list t_batch_list;
5012: l_batch_cnt number;
5013: l_dummy_value number;
5014: l_decode_required boolean;
5015: l_jur_lvl pay_balance_types.jurisdiction_level%type;
5016: --
5017: begin
5018: g_debug := hr_utility.debug_enabled;
5019: --

Line 8024: pay_balance_types pbt,

8020: pay_assignment_actions paa,
8021: pay_run_results prr,
8022: pay_input_values_f piv,
8023: pay_balance_feeds_f pbf,
8024: pay_balance_types pbt,
8025: pay_defined_balances pdb,
8026: pay_balance_dimensions pbd,
8027: pay_run_result_values prrv
8028: where pbd.dimension_level = 'GRP'

Line 8827: pay_balance_types pbt,

8823: from
8824: pay_run_results prr,
8825: pay_run_result_values prrv,
8826: pay_balance_feeds_f pbf,
8827: pay_balance_types pbt,
8828: pay_defined_balances pdb,
8829: pay_balance_dimensions pbd
8830: where pbd.dimension_level = 'ASG'
8831: and pdb.save_run_balance|| decode (pbt.balance_type_id, 0, '', '')= 'Y'