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.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on BEN_OIPL_F

Line 146: oipl_id ben_oipl_f.oipl_id%type,

142: (
143: person_id /*per_people_f */per_all_people_f.person_id%type,
144: pgm_id ben_pgm_f.pgm_id%type,
145: pl_id ben_pl_f.pl_id%type,
146: oipl_id ben_oipl_f.oipl_id%type,
147: dpnt_cvg_strt_dt date,
148: dpnt_cvg_thru_dt date,
149: contact_type hr_lookups.lookup_code%type,
150: actn_cd hr_lookups.lookup_code%type);

Line 1267: select opt_id from ben_oipl_f oipl

1263: and pen.prtt_enrt_rslt_stat_cd is null
1264: ;
1265: --
1266: cursor c_opt(l_oipl_id number) is
1267: select opt_id from ben_oipl_f oipl
1268: where oipl.oipl_id = l_oipl_id
1269: and p_effective_date between
1270: oipl.effective_start_date and oipl.effective_end_date;
1271: