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_PLN_BUS dependencies on BEN_PRTN_ELIGY_RL_F

Line 4651: from ben_prtn_elig_f epa, ben_prtn_elig_prfl_f cep, ben_prtn_eligy_rl_f cer

4647: l_exists varchar2(1);
4648: --
4649: cursor c1 is
4650: select null
4651: from ben_prtn_elig_f epa, ben_prtn_elig_prfl_f cep, ben_prtn_eligy_rl_f cer
4652: where epa.pl_id = p_pl_id
4653: and ((epa.prtn_elig_id = cep.prtn_elig_id
4654: and p_validation_start_date <= cep.effective_end_date
4655: and p_validation_end_date >= cep.effective_start_date)

Line 4664: ben_prtn_eligy_rl_f cer, ben_plip_f plip

4660: --
4661: cursor c2 is
4662: select null
4663: from ben_prtn_elig_f epa, ben_prtn_elig_prfl_f cep,
4664: ben_prtn_eligy_rl_f cer, ben_plip_f plip
4665: where plip.pl_id = p_pl_id
4666: and epa.plip_id = plip.plip_id
4667: and p_effective_date between plip.effective_start_date and plip.effective_end_date
4668: and ((p_validation_start_date <= cep.effective_end_date