[Home] [Help]
1720: -- The above code added by PVELAMUR tp fix the bug 888089
1721: -- The following code added by PVELAMUR to fix bug 900768
1722: SELECT nvl(actual_termination_date,l_payroll_end_date)
1723: into l_termination_date
1724: FROM per_periods_of_service
1725: WHERE person_id = x_person_id and
1726: (date_start between l_payroll_begin_date and l_payroll_end_date) ;
1727: -- The above code added by PVELAMUR tp fix the bug 900768
1728: