APPS.BEN_EVALUATE_RATE_PROFILES dependencies on BEN_CBR_QUALD_BNF

Line 3802: from ben_cbr_quald_bnf cqb

3798: l_mn_poe_num ben_poe_rt_f.mn_poe_num%type;
3799: --
3800: cursor c_get_quald_bnf is
3801: select cqb.*, crp.per_in_ler_id
3802: from ben_cbr_quald_bnf cqb
3803: ,ben_cbr_per_in_ler crp
3804: ,ben_per_in_ler pil
3805: where cqb.quald_bnf_person_id = p_person_id
3806: and cqb.quald_bnf_flag = 'Y'

Line 3822: from ben_cbr_quald_bnf cqb

3818: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
3819: --
3820: cursor c_get_all_quald_bnf(p_cvrd_emp_person_id in number) is
3821: select cqb.*
3822: from ben_cbr_quald_bnf cqb
3823: ,ben_cbr_per_in_ler crp
3824: ,ben_per_in_ler pil
3825: where cqb.cvrd_emp_person_id = p_cvrd_emp_person_id
3826: and cqb.quald_bnf_flag = 'Y'

Line 3910: -- any rows for the person in ben_cbr_quald_bnf. So we are checking the

3906: close c_get_quald_bnf;
3907: --
3908: -- Bug 1566944 Check for new terminations with qualifying event
3909: -- New a termination life event is processes, system can't find
3910: -- any rows for the person in ben_cbr_quald_bnf. So we are checking the
3911: -- Cobra qualifying event flag for the life event.
3912:
3913: --
3914: open c_ler;

Line 4378: l_quald_bnf_flag ben_cbr_quald_bnf.quald_bnf_flag%type;

4374: l_inst_count number;
4375: l_ok boolean := false;
4376: l_rows_found boolean := false;
4377: l_rec per_all_people_f%rowtype;
4378: l_quald_bnf_flag ben_cbr_quald_bnf.quald_bnf_flag%type;
4379: --
4380: cursor c1(p_person_id in number
4381: ,p_lf_evt_ocrd_dt in date
4382: ,p_pgm_id in number

Line 4385: from ben_cbr_quald_bnf cqb

4381: ,p_lf_evt_ocrd_dt in date
4382: ,p_pgm_id in number
4383: ,p_ptip_id in number) is
4384: select cqb.quald_bnf_flag
4385: from ben_cbr_quald_bnf cqb
4386: ,ben_cbr_per_in_ler crp
4387: ,ben_per_in_ler pil
4388: where cqb.quald_bnf_person_id = p_person_id
4389: and cqb.pgm_id = nvl(p_pgm_id,cqb.pgm_id)