DBA Data[Home] [Help]

APPS.PSP_PREGEN dependencies on PER_PERIODS_OF_SERVICE

Line 1721: FROM per_periods_of_service

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