APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 190: p_dimension in pay_balance_dimensions.dimension_name%type,

186: function get_balance_value
187: (
188: p_assignment_id in per_all_assignments_f.assignment_id%type,
189: p_balance_name in pay_balance_types.balance_name%type,
190: p_dimension in pay_balance_dimensions.dimension_name%type,
191: p_effective_date in date
192: )
193: return number is
194:

Line 244: pay_balance_dimensions dim,

240: select def.defined_balance_id
241: into l_defined_bal_id
242: from pay_defined_balances def,
243: pay_balance_types pbt,
244: pay_balance_dimensions dim,
245: pay_balance_types_tl pbt_tl
246: where pbt_tl.balance_name = p_balance_name
247: and pbt_tl.language = 'US'
248: and pbt_tl.balance_type_id = pbt.balance_type_id

Line 1093: l_dimension pay_balance_dimensions.dimension_name%type:= '_ASG_TAX_MTD';

1089: l_ovn number;
1090:
1091: l_assignment_action_id number;
1092:
1093: l_dimension pay_balance_dimensions.dimension_name%type:= '_ASG_TAX_MTD';
1094: l_balance_name pay_balance_types_tl.balance_name%type;
1095:
1096: l_temp_gt_bal number := 0;
1097: l_gross_taxable_remuneration number := 0;