DBA Data[Home] [Help]

APPS.PQP_GB_OSP_FUNCTIONS dependencies on SSP_SSP_ENTRIES_V

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

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
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