APPS.HRI_OPL_BEN_ELIG_ENRL dependencies on BEN_LER_F

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

202: p_sqlstr := p_sqlstr || ' (SELECT MAX(pil.lf_evt_ocrd_dt) lf_evt_ocrd_dt';
203: p_sqlstr := p_sqlstr || ' , pil.business_group_id';
204: p_sqlstr := p_sqlstr || ' , pil.ler_id';
205: p_sqlstr := p_sqlstr || ' FROM ben_per_in_ler pil, ';
206: p_sqlstr := p_sqlstr || ' ben_ler_f ler ';
207: p_sqlstr := p_sqlstr || ' WHERE pil.ler_id = ler.ler_id ';
208: p_sqlstr := p_sqlstr || ' AND ler.typ_cd = ''SCHEDDO''';
209: p_sqlstr := p_sqlstr || ' AND pil.per_in_ler_stat_cd = ''STRTD''';
210: p_sqlstr := p_sqlstr || ' AND pil.lf_evt_ocrd_dt >= ';

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

240: -- Use Profiles to limit entries base on life event occured date.
241: p_sqlstr := ' ';
242: p_sqlstr := p_sqlstr || 'SELECT DISTINCT pil.person_id object_id ';
243: p_sqlstr := p_sqlstr || ' FROM ben_per_in_ler pil, ';
244: p_sqlstr := p_sqlstr || ' ben_ler_f ler ';
245: p_sqlstr := p_sqlstr || ' WHERE pil.ler_id = ler.ler_id ';
246: p_sqlstr := p_sqlstr || ' AND ler.typ_cd = ''SCHEDDO'' ';
247: p_sqlstr := p_sqlstr || ' AND pil.lf_evt_ocrd_dt >= ';
248: p_sqlstr := p_sqlstr || ' TO_DATE('''||TO_CHAR(g_global_start_date,'MM/DD/YYYY') || ''',''MM/DD/YYYY'') ';

Line 601: ben_ler_f ler

597: CURSOR c_bckdt_void_pil IS
598: SELECT per_in_ler_id,
599: pil.per_in_ler_stat_cd
600: FROM ben_per_in_ler pil,
601: ben_ler_f ler
602: WHERE pil.lf_evt_ocrd_dt = l_pil_rec.lf_evt_ocrd_dt
603: AND pil.ler_id = ler.ler_id
604: AND ler.typ_cd = 'SCHEDDO'
605: AND pil.person_id = p_person_id

Line 1287: ben_ler_f ler

1283: pil.lf_evt_ocrd_dt,
1284: pil.per_in_ler_stat_cd,
1285: pil.business_group_id
1286: FROM ben_per_in_ler pil,
1287: ben_ler_f ler
1288: WHERE pil.ler_id = ler.ler_id
1289: AND ler.typ_cd = 'SCHEDDO'
1290: AND pil.per_in_ler_stat_cd IN ('STRTD','PROCD')
1291: AND pil.lf_evt_ocrd_dt >= g_global_start_date

Line 1302: ben_ler_f ler1

1298: pil3.business_group_id
1299: FROM ben_per_in_ler pil3,
1300: (SELECT MAX(pil1.per_in_ler_id) per_in_ler_id
1301: FROM ben_per_in_ler pil1,
1302: ben_ler_f ler1
1303: WHERE pil1.ler_id = ler1.ler_id
1304: AND ler1.typ_cd = 'SCHEDDO'
1305: AND pil1.per_in_ler_stat_cd IN ('BCKDT','VOIDD')
1306: AND pil1.lf_evt_ocrd_dt >= g_global_start_date

Line 1311: ben_ler_f ler2

1307: AND pil1.person_id BETWEEN p_start_object_id AND p_end_object_id
1308: AND NOT EXISTS (SELECT null
1309: -- DO NOT pick up Backed/Voided events, if a Started/Processed Event exists.
1310: FROM ben_per_in_ler pil2,
1311: ben_ler_f ler2
1312: WHERE pil2.lf_evt_ocrd_dt = pil1.lf_evt_ocrd_dt
1313: AND pil2.person_id = pil1.person_id
1314: AND pil2.per_in_ler_stat_cd IN ('STRTD','PROCD')
1315: AND pil2.ler_id = ler2.ler_id

Line 1336: ben_ler_f ler

1332: (SELECT MAX(pil.lf_evt_ocrd_dt) lf_evt_ocrd_dt
1333: , pil.business_group_id
1334: , pil.ler_id
1335: FROM ben_per_in_ler pil,
1336: ben_ler_f ler
1337: WHERE pil.ler_id = ler.ler_id
1338: AND ler.typ_cd = 'SCHEDDO'
1339: AND pil.per_in_ler_stat_cd = 'STRTD'
1340: AND pil.lf_evt_ocrd_dt BETWEEN ler.effective_start_date