APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 191: p_dimension in pay_balance_dimensions.dimension_name%type,

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

Line 245: pay_balance_dimensions dim,

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

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

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