APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on PAY_BALANCE_TYPES

Line 190: p_balance_name in pay_balance_types.balance_name%type,

186: --------------------------------------------------------------------------*/
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

Line 244: pay_balance_types pbt,

240:
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'

Line 246: pay_balance_types_tl pbt_tl

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
250: and pbt.legislation_code = 'ZA'

Line 1096: l_balance_name pay_balance_types_tl.balance_name%type;

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;
1100: l_gross_uif_remuneration number := 0;