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_SSP_ENTRIES_V

Line 12154: (select 1 from SSP_SSP_ENTRIES_V where person_id = l_person_id

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
12155: and c_date between date_from and date_to
12156: MINUS
12157: SELECT 1 FROM ssp_stoppages_v x, per_absence_attendances y
12158: WHERE X.absence_attendance_id = y.absence_attendance_id AND y.person_id = l_person_id