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 12157: SELECT 1 FROM ssp_stoppages_v x, per_absence_attendances y

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
12159: AND c_date BETWEEN withhold_from AND withhold_to
12160: -- added for Bug 7304886
12161: -- The Work-Off days falling in between Waiting days should NOT be

Line 12168: FROM ssp_stoppages_v x, per_absence_attendances y

12164: select 1 from
12165: (SELECT min(withhold_from) min_withhold_from
12166: , max(withhold_to) max_withhold_to
12167: , X.absence_attendance_id
12168: FROM ssp_stoppages_v x, per_absence_attendances y
12169: WHERE X.absence_attendance_id = y.absence_attendance_id
12170: AND y.person_id = l_person_id
12171: AND x.reason = 'Waiting day'
12172: GROUP BY X.absence_attendance_id