DBA Data[Home] [Help]

APPS.PAY_NL_REM_REPORT dependencies on PAY_NL_EOY_PKG

Line 1960: l_wage_tax_income := pay_nl_eoy_pkg.get_prev_year_tax_income(r_other_emp_details.assignment_id,

1956: OPEN csr_other_emp_details(r_person_details.sofi_number);
1957: FETCH csr_other_emp_details INTO r_other_emp_details;
1958:
1959: IF r_other_emp_details.rank =1 AND csr_person_details%FOUND THEN
1960: l_wage_tax_income := pay_nl_eoy_pkg.get_prev_year_tax_income(r_other_emp_details.assignment_id,
1961: add_months(l_reporting_end_date,12));
1962:
1963: IF l_wage_tax_income>=p_threshold_limit THEN
1964: t_single_personid_details(l_per_index).employee_number := r_other_emp_details.employee_number;

Line 1985: l_wage_tax_income := pay_nl_eoy_pkg.get_prev_year_tax_income(r_other_emp_details.assignment_id,

1981:
1982: <>
1983: LOOP
1984: IF csr_other_emp_details%FOUND AND l_prev_rank<>r_other_emp_details.rank THEN
1985: l_wage_tax_income := pay_nl_eoy_pkg.get_prev_year_tax_income(r_other_emp_details.assignment_id,
1986: add_months(l_reporting_end_date,12));
1987: t_individual_person_details(i).employee_number := r_other_emp_details.employee_number;
1988: t_individual_person_details(i).employee_name := r_other_emp_details.employee_name;
1989: t_individual_person_details(i).employer_name := r_other_emp_details.employer_name;