APPS.BEN_EXT_PURGE dependencies on BEN_EXT_CHG_EVT_LOG

Line 205: from ben_ext_chg_evt_log cel

201: select cel.person_id,
202: cel.object_version_number,
203: cel.ext_chg_evt_log_id ,
204: cel.chg_eff_dt
205: from ben_ext_chg_evt_log cel
206: where (cel.person_id = p_person_id
207: or p_person_id is null )
208: and (trunc(cel.chg_eff_dt) <= p_eff_date
209: or p_eff_date is null )

Line 229: l_ext_chg_evt_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%type ;

225: l_log_count number := 0 ;
226: l_person_id number ;
227: l_person_count number := 0;
228: l_prv_person_id number := -1 ;
229: l_ext_chg_evt_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%type ;
230: l_effective_date date ;
231: l_eff_date date ;
232: l_actual_date date ;
233: l_person_name per_all_people_f.full_name%type ;