DBA Data[Home] [Help]

APPS.PAY_ZA_EMP201 dependencies on PAY_ZA_PAYROLL_ACTION_PKG

Line 1080: l_defined_balance_lst(l_loop_count).defined_balance_id := pay_za_payroll_action_pkg.defined_balance_id(balance.balance_name, '_ASG_RUN');

1076: hr_utility.set_location(l_proc, 73);
1077: l_loop_count := l_loop_count + 1;
1078: hr_utility.trace('l_loop_count : '||l_loop_count);
1079:
1080: l_defined_balance_lst(l_loop_count).defined_balance_id := pay_za_payroll_action_pkg.defined_balance_id(balance.balance_name, '_ASG_RUN');
1081: hr_utility.trace(' balance.balance_name : '|| balance.balance_name);
1082: hr_utility.trace(' l_defined_balance_lst(l_loop_count).defined_balance_id : '|| l_defined_balance_lst(l_loop_count).defined_balance_id);
1083:
1084: -- Initializing the l_net_bal_table to Zero

Line 1132: l_tax_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('Tax', '_ASG_TAX_MTD');

1128: end if;
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');

Line 1136: l_paye_rem_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('Net PAYE Taxable Income', '_ASG_TAX_MTD');

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);
1138:
1139: -- Bug 14081001
1140: if l_asg_act_id_table.COUNT > 0 then

Line 1158: l_net_taxable_inc_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('Net Taxable Income', '_ASG_TAX_MTD');

1154: if l_sdl_exemption = 'N' then
1155:
1156: hr_utility.set_location(l_proc, 90);
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);

Line 1159: l_skills_levy_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('Skills Levy', '_ASG_TAX_MTD');

1155:
1156: hr_utility.set_location(l_proc, 90);
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:

Line 1185: l_temp_emp_hours_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('ZA_TEMPORARY_EMPLOYEE_HOURS', '_ASG_TAX_MTD');

1181:
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);

Line 1206: l_uif_ee_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('UIF Employee Contribution', '_ASG_TAX_MTD');

1202: l_uif_remuneration := 0 ;
1203: else
1204: hr_utility.set_location(l_proc, 130);
1205: -- get UIF amount and Remuneration
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);

Line 1207: l_uif_er_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('UIF Employer Contribution', '_ASG_TAX_MTD');

1203: else
1204: hr_utility.set_location(l_proc, 130);
1205: -- get UIF amount and Remuneration
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);

Line 1208: l_uifable_income_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('Total UIFable Income', '_ASG_TAX_MTD');

1204: hr_utility.set_location(l_proc, 130);
1205: -- get UIF amount and Remuneration
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:

Line 1285: l_gross_remun_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('Gross Remuneration', '_ASG_CAL_MTD');

1281: end if ;
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

Line 1346: l_tax_dim_ytd := pay_za_payroll_action_pkg.defined_balance_id('Tax', '_ASG_TAX_YTD');

1342: close csr_check_asg_termination ;
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);

Line 1349: l_site_dim_ytd := pay_za_payroll_action_pkg.defined_balance_id('SITE', '_ASG_TAX_YTD');

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:
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);

Line 1352: l_paye_dim_ytd := pay_za_payroll_action_pkg.defined_balance_id('PAYE', '_ASG_TAX_YTD');

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:
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);