DBA Data[Home] [Help]

APPS.PQP_GB_OSP_FUNCTIONS dependencies on SSP_SPPA_ENTRIES_V

Line 12182: select 1 from SSP_SPPA_ENTRIES_V a3 , per_absence_attendances b3

12178: select 1 from SSP_SAP_ENTRIES_V a2 , per_absence_attendances b2
12179: where a2.person_id = b2.person_id and a2.person_id = l_person_id
12180: and c_date between date_from and least(nvl(date_end, date_to), date_to )
12181: union
12182: select 1 from SSP_SPPA_ENTRIES_V a3 , per_absence_attendances b3
12183: where a3.person_id = b3.person_id and a3.person_id = l_person_id
12184: and c_date between date_from and least(nvl(date_end, date_to), date_to );
12185:
12186: CURSOR cur_person_id is