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_ZA_EMP201 dependencies on PAY_BALANCE_PKG

Line 924: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval

920: l_pay_effective_date date ;
921:
922: -- Bug 14081001
923: l_loop_count NUMBER;
924: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
925: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
926: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval
927:
928: TYPE t_asg_act_id_table IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 925: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval

921:
922: -- Bug 14081001
923: l_loop_count NUMBER;
924: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
925: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
926: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval
927:
928: TYPE t_asg_act_id_table IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
929:

Line 926: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval

922: -- Bug 14081001
923: l_loop_count NUMBER;
924: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
925: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
926: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval
927:
928: TYPE t_asg_act_id_table IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
929:
930: TYPE t_net_bal_rec is record

Line 1112: pay_balance_pkg.get_value(p_assignment_action_id => l_asg_act_id_table(i)

1108: for i in l_asg_act_id_table.first .. l_asg_act_id_table.last
1109: loop
1110: hr_utility.set_location(l_proc, 75);
1111: hr_utility.trace(' l_asg_act_id_table(i) : '|| l_asg_act_id_table(i));
1112: pay_balance_pkg.get_value(p_assignment_action_id => l_asg_act_id_table(i)
1113: , p_defined_balance_lst => l_defined_balance_lst
1114: , p_context_lst => l_context_lst
1115: , p_output_table => l_output_table
1116: );

Line 1133: l_tax := nvl(pay_balance_pkg.get_value(l_tax_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);

1129: -- Bug 14081001
1130:
1131: -- Get PAYE Data
1132: l_tax_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('Tax', '_ASG_TAX_MTD');
1133: l_tax := nvl(pay_balance_pkg.get_value(l_tax_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);
1134:
1135: -- Get PAYE Remuneration
1136: l_paye_rem_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('Net PAYE Taxable Income', '_ASG_TAX_MTD');
1137: l_paye_remuneration := nvl(pay_balance_pkg.get_value(l_paye_rem_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);

Line 1137: l_paye_remuneration := nvl(pay_balance_pkg.get_value(l_paye_rem_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);

1133: l_tax := nvl(pay_balance_pkg.get_value(l_tax_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);
1134:
1135: -- Get PAYE Remuneration
1136: l_paye_rem_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('Net PAYE Taxable Income', '_ASG_TAX_MTD');
1137: l_paye_remuneration := nvl(pay_balance_pkg.get_value(l_paye_rem_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);
1138:
1139: -- Bug 14081001
1140: if l_asg_act_id_table.COUNT > 0 then
1141: l_tax := l_tax + l_net_bal_table('Tax').bal_value ;

Line 1161: l_leviable_amt := nvl(pay_balance_pkg.get_value(l_net_taxable_inc_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);

1157:
1158: l_net_taxable_inc_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('Net Taxable Income', '_ASG_TAX_MTD');
1159: l_skills_levy_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('Skills Levy', '_ASG_TAX_MTD');
1160:
1161: l_leviable_amt := nvl(pay_balance_pkg.get_value(l_net_taxable_inc_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);
1162: l_sdl_amt := nvl(pay_balance_pkg.get_value(l_skills_levy_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);
1163:
1164: -- Bug 14081001
1165: if l_asg_act_id_table.COUNT > 0 then

Line 1162: l_sdl_amt := nvl(pay_balance_pkg.get_value(l_skills_levy_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);

1158: l_net_taxable_inc_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('Net Taxable Income', '_ASG_TAX_MTD');
1159: l_skills_levy_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('Skills Levy', '_ASG_TAX_MTD');
1160:
1161: l_leviable_amt := nvl(pay_balance_pkg.get_value(l_net_taxable_inc_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);
1162: l_sdl_amt := nvl(pay_balance_pkg.get_value(l_skills_levy_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);
1163:
1164: -- Bug 14081001
1165: if l_asg_act_id_table.COUNT > 0 then
1166: l_leviable_amt := l_leviable_amt + l_net_bal_table('Net Taxable Income').bal_value ;

Line 1186: l_temp_emp_hours := nvl(pay_balance_pkg.get_value(l_temp_emp_hours_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);

1182: -- Remuneration for employee's with a UIF reason for Non-Contribution must be excluded as must
1183: -- Remuneration of Independent Contractors and any non-natural persons (Nature of Person = D, E, F, G, H or K).
1184:
1185: l_temp_emp_hours_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('ZA_TEMPORARY_EMPLOYEE_HOURS', '_ASG_TAX_MTD');
1186: l_temp_emp_hours := nvl(pay_balance_pkg.get_value(l_temp_emp_hours_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);
1187:
1188: if l_last_run_payroll_action_id is null then -- No payroll run for this calendar month
1189: hr_utility.set_location(l_proc, 110);
1190: l_uif_amt := 0 ;

Line 1210: l_uif_ee_contr := nvl(pay_balance_pkg.get_value(l_uif_ee_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);

1206: l_uif_ee_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('UIF Employee Contribution', '_ASG_TAX_MTD');
1207: l_uif_er_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('UIF Employer Contribution', '_ASG_TAX_MTD');
1208: l_uifable_income_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('Total UIFable Income', '_ASG_TAX_MTD');
1209:
1210: l_uif_ee_contr := nvl(pay_balance_pkg.get_value(l_uif_ee_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);
1211: l_uif_er_contr := nvl(pay_balance_pkg.get_value(l_uif_er_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);
1212:
1213: -- Bug 14081001
1214: if l_asg_act_id_table.COUNT > 0 then

Line 1211: l_uif_er_contr := nvl(pay_balance_pkg.get_value(l_uif_er_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);

1207: l_uif_er_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('UIF Employer Contribution', '_ASG_TAX_MTD');
1208: l_uifable_income_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('Total UIFable Income', '_ASG_TAX_MTD');
1209:
1210: l_uif_ee_contr := nvl(pay_balance_pkg.get_value(l_uif_ee_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);
1211: l_uif_er_contr := nvl(pay_balance_pkg.get_value(l_uif_er_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);
1212:
1213: -- Bug 14081001
1214: if l_asg_act_id_table.COUNT > 0 then
1215: l_uif_ee_contr := l_uif_ee_contr + l_net_bal_table('UIF Employee Contribution').bal_value ;

Line 1222: l_uif_remuneration := nvl(pay_balance_pkg.get_value(l_uifable_income_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);

1218: -- Bug 14081001
1219:
1220: l_uif_amt := l_uif_ee_contr+ l_uif_er_contr ;
1221:
1222: l_uif_remuneration := nvl(pay_balance_pkg.get_value(l_uifable_income_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);
1223:
1224: -- Bug 14081001
1225: if l_asg_act_id_table.COUNT > 0 then
1226: l_uif_remuneration := l_uif_remuneration + l_net_bal_table('Total UIFable Income').bal_value ;

Line 1286: l_gross_remun := nvl(pay_balance_pkg.get_value(l_gross_remun_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0) ;

1282:
1283: hr_utility.trace('tax_status :'||l_tax_status);
1284:
1285: l_gross_remun_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('Gross Remuneration', '_ASG_CAL_MTD');
1286: l_gross_remun := nvl(pay_balance_pkg.get_value(l_gross_remun_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0) ;
1287:
1288: -- Bug 14081001
1289: if l_asg_act_id_table.COUNT > 0 then
1290: l_gross_remun := l_gross_remun + l_net_bal_table('Gross Remuneration').bal_value ;

Line 1347: l_tax_ytd := nvl(pay_balance_pkg.get_value(l_tax_dim_ytd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);

1343:
1344: if l_asg_terminated = 'Y' then -- assignment is terminated
1345: hr_utility.set_location(l_proc, 250);
1346: l_tax_dim_ytd := pay_za_payroll_action_pkg.defined_balance_id('Tax', '_ASG_TAX_YTD');
1347: l_tax_ytd := nvl(pay_balance_pkg.get_value(l_tax_dim_ytd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);
1348:
1349: l_site_dim_ytd := pay_za_payroll_action_pkg.defined_balance_id('SITE', '_ASG_TAX_YTD');
1350: l_site := nvl(pay_balance_pkg.get_value(l_site_dim_ytd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);
1351:

Line 1350: l_site := nvl(pay_balance_pkg.get_value(l_site_dim_ytd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);

1346: l_tax_dim_ytd := pay_za_payroll_action_pkg.defined_balance_id('Tax', '_ASG_TAX_YTD');
1347: l_tax_ytd := nvl(pay_balance_pkg.get_value(l_tax_dim_ytd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);
1348:
1349: l_site_dim_ytd := pay_za_payroll_action_pkg.defined_balance_id('SITE', '_ASG_TAX_YTD');
1350: l_site := nvl(pay_balance_pkg.get_value(l_site_dim_ytd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);
1351:
1352: l_paye_dim_ytd := pay_za_payroll_action_pkg.defined_balance_id('PAYE', '_ASG_TAX_YTD');
1353: l_paye := nvl(pay_balance_pkg.get_value(l_paye_dim_ytd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);
1354:

Line 1353: l_paye := nvl(pay_balance_pkg.get_value(l_paye_dim_ytd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);

1349: l_site_dim_ytd := pay_za_payroll_action_pkg.defined_balance_id('SITE', '_ASG_TAX_YTD');
1350: l_site := nvl(pay_balance_pkg.get_value(l_site_dim_ytd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);
1351:
1352: l_paye_dim_ytd := pay_za_payroll_action_pkg.defined_balance_id('PAYE', '_ASG_TAX_YTD');
1353: l_paye := nvl(pay_balance_pkg.get_value(l_paye_dim_ytd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);
1354:
1355: if l_tax_ytd <> 0 and l_site = 0 and l_paye = 0 then -- SITE/PAYE split not calculated
1356: hr_utility.set_location(l_proc, 255);
1357: l_raise_warning := 'Y' ;