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 12150: select 1 from SSP_SMP_ENTRIES_V a1 , per_absence_attendances b1

12146: g_package_name||'get_ssp_smp_paid_days';
12147:
12148:
12149: Cursor cur_no_paid_days(p_date date) IS
12150: select 1 from SSP_SMP_ENTRIES_V a1 , per_absence_attendances b1
12151: where a1.person_id = b1.person_id and a1.person_id = l_person_id
12152: and c_date between date_from and least(nvl(date_end, date_to), date_to)
12153: union
12154: (select 1 from SSP_SSP_ENTRIES_V where person_id = l_person_id