[Home] [Help]
1108: l_sen_city_field := l_sen_postal_code || l_sen_city;
1109: l_tax_address_field := l_street_name || l_house_number || l_house_no_add;
1110: l_tax_city_field := l_postal_code || l_city;
1111: -- hr_utility.set_location('Going to retrieve the Data of org struct id,frequency and cust no'||l_reporting_date,600);
1112: l_org_struct_version_id := pay_nl_taxoffice_archive.get_org_hierarchy(l_org_struct_id,l_reporting_date);
1113: l_frequency := hr_nl_org_info.get_reporting_frequency(l_employer);
1114: l_customer_number := hr_nl_org_info.get_customer_number(l_employer);
1115:
1116: -- hr_utility.set_location('Going to perform mandatory check the Data in Range Code',600);
1443: hr_utility.set_location('p_effective_date'||l_effective_date,425);
1444: hr_utility.set_location('p_business_group_id'||l_business_group_id,425);
1445: end if;
1446:
1447: l_org_struct_version_id:=pay_nl_taxoffice_archive.get_org_hierarchy(l_org_struct_id,l_reporting_date);
1448: l_frequency := hr_nl_org_info.get_reporting_frequency(l_employer_id);
1449:
1450: -- hr_utility.set_location('l_frequency'||l_frequency,425);
1451: if l_frequency = 'K' then
1488: g_error_count := 0;
1489: l_si_provider_check := check_Asg_si_provider(l_asg_employer_id,l_si_provider_id,l_assignment_id);
1490: -- hr_utility.set_location('l_si_provider_check'||l_si_provider_check,500);
1491: -- Fetch maximum assignment action id in the reporting period
1492: l_max_assgt_act_id := pay_nl_taxoffice_archive.get_max_assgt_act_id(l_assignment_id,l_reporting_start_date,l_reporting_end_date);
1493: -- hr_utility.set_location('max assignmentid'||l_max_assgt_act_id,600);
1494:
1495: IF (l_si_provider_check = 1 AND l_max_assgt_act_id is not null) THEN
1496: l_number := get_tax_details(l_max_assgt_act_id,l_wage_tax_discount,l_tax_code,l_labour_relation_code);
1493: -- hr_utility.set_location('max assignmentid'||l_max_assgt_act_id,600);
1494:
1495: IF (l_si_provider_check = 1 AND l_max_assgt_act_id is not null) THEN
1496: l_number := get_tax_details(l_max_assgt_act_id,l_wage_tax_discount,l_tax_code,l_labour_relation_code);
1497: l_income_code := pay_nl_taxoffice_archive.get_income_code(l_assignment_id,l_reporting_start_date,l_reporting_end_date);
1498: l_health_insurance := get_health_insurance(l_assignment_id,l_reporting_date);
1499: --l_work_pattern := get_work_pattern(l_soft_coding_keyflex_id);
1500: -- hr_utility.set_location('FETCHED HEALTH INSURANCE'||l_health_insurance,400);
1501: get_working_schedule(l_assignment_id,l_working_schedule,l_reporting_start_date,l_reporting_end_date);