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_STOPPAGES_V

Line 12128: SELECT 1 FROM ssp_stoppages_v x, per_absence_attendances y

12124: union
12125: (select 1 from SSP_SSP_ENTRIES_V where person_id = l_person_id
12126: and c_date between date_from and date_to
12127: MINUS
12128: SELECT 1 FROM ssp_stoppages_v x, per_absence_attendances y
12129: WHERE X.absence_attendance_id = y.absence_attendance_id AND y.person_id = l_person_id
12130: AND c_date BETWEEN withhold_from AND withhold_to
12131: -- added for Bug 7304886
12132: -- The Work-Off days falling in between Waiting days should NOT be

Line 12139: FROM ssp_stoppages_v x, per_absence_attendances y

12135: select 1 from
12136: (SELECT min(withhold_from) min_withhold_from
12137: , max(withhold_to) max_withhold_to
12138: , X.absence_attendance_id
12139: FROM ssp_stoppages_v x, per_absence_attendances y
12140: WHERE X.absence_attendance_id = y.absence_attendance_id
12141: AND y.person_id = l_person_id
12142: AND x.reason = 'Waiting day'
12143: GROUP BY X.absence_attendance_id