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 4636: ,ben_plip_f cpp

4632: cursor c1(p_plip_id in number) is
4633: select null
4634: from ben_prtt_enrt_rslt_f pen
4635: ,ben_elig_cvrd_dpnt_f pdp
4636: ,ben_plip_f cpp
4637: where pen.prtt_enrt_rslt_id = pdp.prtt_enrt_rslt_id
4638: --and pen.prtt_enrt_rslt_stat_cd not in ('BCKDT', 'VOIDD')
4639: and pen.prtt_enrt_rslt_stat_cd is null
4640: and pdp.dpnt_person_id = p_person_id

Line 5110: ben_plip_f cpp,

5106: is
5107: select /*+ bendtlep.check_othr_ptip.pilc1 */
5108: null
5109: from ben_pl_f pln,
5110: ben_plip_f cpp,
5111: ben_ptip_f ctp,
5112: ben_elig_per_f epo
5113: where pln.pl_id = cpp.pl_id
5114: and c_effective_date

Line 5156: ben_plip_f cpp,

5152: is
5153: select /*+ bendtlep.check_othr_ptip.c1 */
5154: null
5155: from ben_pl_f pln,
5156: ben_plip_f cpp,
5157: ben_ptip_f ctp,
5158: ben_pl_regn_f prg,
5159: ben_regn_f reg,
5160: ben_elig_per_f epo,

Line 5768: ,ben_plip_f cpp

5764: --
5765: cursor c1(p_plip_id in number) is
5766: select null
5767: from ben_prtt_enrt_rslt_f pen
5768: ,ben_plip_f cpp
5769: where pen.business_group_id = p_business_group_id
5770: and pen.pgm_id = cpp.pgm_id
5771: and pen.pl_id = cpp.pl_id
5772: and cpp.plip_id = p_plip_id

Line 6018: ben_plip_f cpp,

6014: )
6015: is
6016: select null
6017: from ben_pl_f pln,
6018: ben_plip_f cpp,
6019: ben_ptip_f ctp,
6020: ben_elig_per_f epo,
6021: ben_elig_dpnt edp,
6022: ben_per_in_ler pil