APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on BEN_CBR_QUALD_BNF

Line 7329: l_quald_bnf_flag ben_cbr_quald_bnf.quald_bnf_flag%type;

7325: p_effective_date in date) is
7326: --
7327: l_proc varchar2(100):=g_package||'check_elig_cbr_quald_bnf';
7328: l_inst_dets ben_elp_cache.g_cache_elpecq_instor;
7329: l_quald_bnf_flag ben_cbr_quald_bnf.quald_bnf_flag%type;
7330: l_inst_count number;
7331: l_insttorrw_num binary_integer;
7332: l_ok boolean := false;
7333: l_rows_found boolean := false;

Line 7341: from ben_cbr_quald_bnf cqb

7337: ,p_lf_evt_ocrd_dt in date
7338: ,p_pgm_id in number
7339: ,p_ptip_id in number) is
7340: select cqb.quald_bnf_flag
7341: from ben_cbr_quald_bnf cqb
7342: ,ben_cbr_per_in_ler crp
7343: ,ben_per_in_ler pil
7344: where cqb.quald_bnf_person_id = p_person_id
7345: -- lamc added these next 2 lines