DBA Data[Home] [Help]

APPS.PQP_GB_OSP_FUNCTIONS dependencies on SSP_SPPA_ENTRIES_V

Line 12153: select 1 from SSP_SPPA_ENTRIES_V a3 , per_absence_attendances b3

12149: select 1 from SSP_SAP_ENTRIES_V a2 , per_absence_attendances b2
12150: where a2.person_id = b2.person_id and a2.person_id = l_person_id
12151: and c_date between date_from and least(nvl(date_end, date_to), date_to )
12152: union
12153: select 1 from SSP_SPPA_ENTRIES_V a3 , per_absence_attendances b3
12154: where a3.person_id = b3.person_id and a3.person_id = l_person_id
12155: and c_date between date_from and least(nvl(date_end, date_to), date_to );
12156:
12157: CURSOR cur_person_id is