APPS.HRI_OPL_BEN_ENRL_ACTN dependencies on BEN_LER_F

Line 241: p_sqlstr := p_sqlstr || ' ben_ler_f ler ';

237: p_sqlstr := p_sqlstr || ' (SELECT MAX(pil.lf_evt_ocrd_dt) lf_evt_ocrd_dt';
238: p_sqlstr := p_sqlstr || ' , pil.business_group_id';
239: p_sqlstr := p_sqlstr || ' , pil.ler_id';
240: p_sqlstr := p_sqlstr || ' FROM ben_per_in_ler pil, ';
241: p_sqlstr := p_sqlstr || ' ben_ler_f ler ';
242: p_sqlstr := p_sqlstr || ' WHERE pil.ler_id = ler.ler_id ';
243: p_sqlstr := p_sqlstr || ' AND ler.typ_cd = ''SCHEDDO''';
244: p_sqlstr := p_sqlstr || ' AND pil.per_in_ler_stat_cd = ''STRTD''';
245: p_sqlstr := p_sqlstr || ' AND pil.lf_evt_ocrd_dt >= ';

Line 285: p_sqlstr := p_sqlstr || ' ben_ler_f ler ';

281: -- Use Profiles to limit entries base on life event occured date.
282: p_sqlstr := ' ';
283: p_sqlstr := p_sqlstr || 'SELECT DISTINCT pil.person_id object_id ';
284: p_sqlstr := p_sqlstr || ' FROM ben_per_in_ler pil, ';
285: p_sqlstr := p_sqlstr || ' ben_ler_f ler ';
286: p_sqlstr := p_sqlstr || ' WHERE pil.ler_id = ler.ler_id ';
287: p_sqlstr := p_sqlstr || ' AND ler.typ_cd = ''SCHEDDO'' ';
288: p_sqlstr := p_sqlstr || ' AND pil.per_in_ler_stat_cd IN (''STRTD'',''PROCD'') ';
289: p_sqlstr := p_sqlstr || ' AND pil.lf_evt_ocrd_dt >= ';

Line 737: FROM ben_per_in_ler pil, ben_ler_f ler

733: pil.person_id,
734: pil.lf_evt_ocrd_dt,
735: pil.per_in_ler_stat_cd,
736: pil.business_group_id
737: FROM ben_per_in_ler pil, ben_ler_f ler
738: WHERE pil.ler_id = ler.ler_id
739: AND ler.typ_cd = 'SCHEDDO'
740: AND pil.per_in_ler_stat_cd IN ('STRTD', 'PROCD')
741: AND pil.lf_evt_ocrd_dt >= g_global_start_date

Line 757: ben_ler_f ler

753: (SELECT MAX(pil.lf_evt_ocrd_dt) lf_evt_ocrd_dt
754: , pil.business_group_id
755: , pil.ler_id
756: FROM ben_per_in_ler pil,
757: ben_ler_f ler
758: WHERE pil.ler_id = ler.ler_id
759: AND ler.typ_cd = 'SCHEDDO'
760: AND pil.per_in_ler_stat_cd = 'STRTD'
761: AND pil.lf_evt_ocrd_dt BETWEEN ler.effective_start_date