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_EVALUATE_ELIG_PROFILES dependencies on BEN_PLIP_F

Line 6636: ,ben_plip_f cpp

6632: --
6633: cursor c1(p_plip_id in number,p_date_to_use date) is
6634: select null
6635: from ben_prtt_enrt_rslt_f pen
6636: ,ben_plip_f cpp
6637: where pen.business_group_id = p_business_group_id
6638: and pen.pgm_id = cpp.pgm_id
6639: and pen.pl_id = cpp.pl_id
6640: and cpp.plip_id = p_plip_id

Line 6757: ,ben_plip_f cpp

6753: cursor c1(p_plip_id in number,p_date_to_use date ) is
6754: select null
6755: from ben_prtt_enrt_rslt_f pen
6756: ,ben_elig_cvrd_dpnt_f pdp
6757: ,ben_plip_f cpp
6758: where pen.prtt_enrt_rslt_id = pdp.prtt_enrt_rslt_id
6759: --and pen.prtt_enrt_rslt_stat_cd not in ('BCKDT', 'VOIDD')
6760: and pen.prtt_enrt_rslt_stat_cd is null
6761: and pdp.dpnt_person_id = p_person_id

Line 8914: l_plip_rec ben_plip_f%rowtype;

8910: l_pl_rec ben_pl_f%rowtype;
8911: l_pl3_rec ben_pl_f%rowtype;
8912: l_ptip2_rec ben_ptip_f%rowtype;
8913: l_oipl_rec ben_oipl_f%rowtype;
8914: l_plip_rec ben_plip_f%rowtype;
8915: l_ptip_rec ben_ptip_f%rowtype;
8916: --
8917: l_inst_set ben_elig_rl_cache.g_elig_rl_inst_tbl;
8918: l_elig_rl_cnt number := 0;

Line 9079: from ben_plip_f plip,

9075: and effective_end_date;
9076: --
9077: cursor c_plip_pl_typ(c_effective_date date) is
9078: select pln.pl_typ_id
9079: from ben_plip_f plip,
9080: ben_pl_f pln
9081: where plip_id = p_plip_id
9082: and c_effective_date
9083: between plip.effective_start_date and plip.effective_end_date