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

Line 4583: ,ben_plip_f cpp

4579: cursor c1(p_plip_id in number) is
4580: select null
4581: from ben_prtt_enrt_rslt_f pen
4582: ,ben_elig_cvrd_dpnt_f pdp
4583: ,ben_plip_f cpp
4584: where pen.prtt_enrt_rslt_id = pdp.prtt_enrt_rslt_id
4585: --and pen.prtt_enrt_rslt_stat_cd not in ('BCKDT', 'VOIDD')
4586: and pen.prtt_enrt_rslt_stat_cd is null
4587: and pdp.dpnt_person_id = p_person_id

Line 5053: ben_plip_f cpp,

5049: is
5050: select /*+ bendtlep.check_othr_ptip.pilc1 */
5051: null
5052: from ben_pl_f pln,
5053: ben_plip_f cpp,
5054: ben_ptip_f ctp,
5055: ben_elig_per_f epo
5056: where pln.pl_id = cpp.pl_id
5057: and c_effective_date

Line 5099: ben_plip_f cpp,

5095: is
5096: select /*+ bendtlep.check_othr_ptip.c1 */
5097: null
5098: from ben_pl_f pln,
5099: ben_plip_f cpp,
5100: ben_ptip_f ctp,
5101: ben_pl_regn_f prg,
5102: ben_regn_f reg,
5103: ben_elig_per_f epo,

Line 5711: ,ben_plip_f cpp

5707: --
5708: cursor c1(p_plip_id in number) is
5709: select null
5710: from ben_prtt_enrt_rslt_f pen
5711: ,ben_plip_f cpp
5712: where pen.business_group_id = p_business_group_id
5713: and pen.pgm_id = cpp.pgm_id
5714: and pen.pl_id = cpp.pl_id
5715: and cpp.plip_id = p_plip_id

Line 5961: ben_plip_f cpp,

5957: )
5958: is
5959: select null
5960: from ben_pl_f pln,
5961: ben_plip_f cpp,
5962: ben_ptip_f ctp,
5963: ben_elig_per_f epo,
5964: ben_elig_dpnt edp,
5965: ben_per_in_ler pil