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_CBR_QUALD_BNF

Line 7341: l_quald_bnf_flag ben_cbr_quald_bnf.quald_bnf_flag%type;

7337: p_effective_date in date) is
7338: --
7339: l_proc varchar2(100):=g_package||'check_elig_cbr_quald_bnf';
7340: l_inst_dets ben_elp_cache.g_cache_elpecq_instor;
7341: l_quald_bnf_flag ben_cbr_quald_bnf.quald_bnf_flag%type;
7342: l_cbr_elig_perd_strt_dt ben_cbr_quald_bnf.cbr_elig_perd_strt_dt%type;
7343:
7344: l_inst_count number;
7345: l_insttorrw_num binary_integer;

Line 7342: l_cbr_elig_perd_strt_dt ben_cbr_quald_bnf.cbr_elig_perd_strt_dt%type;

7338: --
7339: l_proc varchar2(100):=g_package||'check_elig_cbr_quald_bnf';
7340: l_inst_dets ben_elp_cache.g_cache_elpecq_instor;
7341: l_quald_bnf_flag ben_cbr_quald_bnf.quald_bnf_flag%type;
7342: l_cbr_elig_perd_strt_dt ben_cbr_quald_bnf.cbr_elig_perd_strt_dt%type;
7343:
7344: l_inst_count number;
7345: l_insttorrw_num binary_integer;
7346: l_ok boolean := false;

Line 7356: from ben_cbr_quald_bnf cqb

7352: ,p_pgm_id in number
7353: ,p_ptip_id in number) is
7354: select cqb.quald_bnf_flag
7355: ,cqb.cbr_elig_perd_strt_dt
7356: from ben_cbr_quald_bnf cqb
7357: ,ben_cbr_per_in_ler crp
7358: ,ben_per_in_ler pil
7359: where cqb.quald_bnf_person_id = p_person_id
7360: -- lamc added these next 2 lines