eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_OSP_FUNCTIONS dependencies on SSP_SMP_ENTRIES_V

Line 12121: select 1 from SSP_SMP_ENTRIES_V a1 , per_absence_attendances b1

12117: g_package_name||'get_ssp_smp_paid_days';
12118:
12119:
12120: Cursor cur_no_paid_days(p_date date) IS
12121: select 1 from SSP_SMP_ENTRIES_V a1 , per_absence_attendances b1
12122: where a1.person_id = b1.person_id and a1.person_id = l_person_id
12123: and c_date between date_from and least(nvl(date_end, date_to), date_to)
12124: union
12125: (select 1 from SSP_SSP_ENTRIES_V where person_id = l_person_id