eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRI_OPL_BEN_ELIG_ENRL dependencies on BEN_PER_IN_LER

Line 201: p_sqlstr := p_sqlstr || ' FROM ben_per_in_ler pil,';

197: -- for the Latest Open LE in each BG.
198: --
199: p_sqlstr := ' ';
200: p_sqlstr := p_sqlstr || 'SELECT DISTINCT pil.person_id object_id';
201: p_sqlstr := p_sqlstr || ' FROM ben_per_in_ler pil,';
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, ';

Line 205: p_sqlstr := p_sqlstr || ' FROM ben_per_in_ler pil, ';

201: p_sqlstr := p_sqlstr || ' FROM ben_per_in_ler pil,';
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''';

Line 243: p_sqlstr := p_sqlstr || ' FROM ben_per_in_ler pil, ';

239: -- Select all PERSONs for whom an Open Enrollment is either in Started or Processed State
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 >= ';

Line 551: ben_per_in_ler pil,

547: ,pil.per_in_ler_id per_in_ler_id
548: ,pel.pgm_id pgm_id
549: ,pel.pil_elctbl_chc_popl_id pil_elctbl_chc_popl_id
550: FROM ben_pil_elctbl_chc_popl pel,
551: ben_per_in_ler pil,
552: ben_ptnl_ler_for_per ppl
553: WHERE pel.per_in_ler_id = pil.per_in_ler_id
554: AND ppl.ptnl_ler_for_per_id = pil.ptnl_ler_for_per_id
555: AND pil.per_in_ler_id = p_pil_rec.per_in_ler_id

Line 590: FROM ben_per_in_ler pil,

586: AND ppl.ptnl_ler_for_per_stat_cd <> 'MNL') -- 4514159
587: THEN 'BCKDT'
588: ELSE pil.per_in_ler_stat_cd END ) per_in_ler_stat_cd
589: ,pil.business_group_id
590: FROM ben_per_in_ler pil,
591: ben_ptnl_ler_for_per ppl
592: WHERE pil.per_in_ler_id = p_per_in_ler_id
593: AND ppl.ptnl_ler_for_per_id = pil.ptnl_ler_for_per_id;
594:

Line 600: FROM ben_per_in_ler pil,

596:
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'

Line 1286: FROM ben_per_in_ler pil,

1282: pil.person_id,
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')

Line 1299: FROM ben_per_in_ler pil3,

1295: pil3.person_id,
1296: pil3.lf_evt_ocrd_dt,
1297: pil3.per_in_ler_stat_cd,
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

Line 1301: FROM ben_per_in_ler pil1,

1297: pil3.per_in_ler_stat_cd,
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')

Line 1310: FROM ben_per_in_ler pil2,

1306: AND pil1.lf_evt_ocrd_dt >= g_global_start_date
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')

Line 1331: FROM ben_per_in_ler pil,

1327: pil.person_id,
1328: pil.lf_evt_ocrd_dt,
1329: pil.per_in_ler_stat_cd,
1330: pil.business_group_id
1331: FROM ben_per_in_ler pil,
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,

Line 1335: FROM ben_per_in_ler pil,

1331: FROM ben_per_in_ler pil,
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'