DBA Data[Home] [Help]

APPS.PSP_PREGEN dependencies on PER_PERIODS_OF_SERVICE

Line 1724: FROM per_periods_of_service

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: