APPS.BEN_EVALUATE_RATE_PROFILES dependencies on BEN_CBR_QUALD_BNF

Line 3808: from ben_cbr_quald_bnf cqb

3804: l_mn_poe_num ben_poe_rt_f.mn_poe_num%type;
3805: --
3806: cursor c_get_quald_bnf is
3807: select cqb.*, crp.per_in_ler_id
3808: from ben_cbr_quald_bnf cqb
3809: ,ben_cbr_per_in_ler crp
3810: ,ben_per_in_ler pil
3811: where cqb.quald_bnf_person_id = p_person_id
3812: and cqb.quald_bnf_flag = 'Y'

Line 3828: from ben_cbr_quald_bnf cqb

3824: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
3825: --
3826: cursor c_get_all_quald_bnf(p_cvrd_emp_person_id in number) is
3827: select cqb.*
3828: from ben_cbr_quald_bnf cqb
3829: ,ben_cbr_per_in_ler crp
3830: ,ben_per_in_ler pil
3831: where cqb.cvrd_emp_person_id = p_cvrd_emp_person_id
3832: and cqb.quald_bnf_flag = 'Y'

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

3932: close c_get_quald_bnf;
3933: --
3934: -- Bug 1566944 Check for new terminations with qualifying event
3935: -- New a termination life event is processes, system can't find
3936: -- any rows for the person in ben_cbr_quald_bnf. So we are checking the
3937: -- Cobra qualifying event flag for the life event.
3938:
3939: --
3940: open c_ler;

Line 4431: l_quald_bnf_flag ben_cbr_quald_bnf.quald_bnf_flag%type;

4427: l_inst_count number;
4428: l_ok boolean := false;
4429: l_rows_found boolean := false;
4430: l_rec per_all_people_f%rowtype;
4431: l_quald_bnf_flag ben_cbr_quald_bnf.quald_bnf_flag%type;
4432: --
4433: cursor c1(p_person_id in number
4434: ,p_lf_evt_ocrd_dt in date
4435: ,p_pgm_id in number

Line 4438: from ben_cbr_quald_bnf cqb

4434: ,p_lf_evt_ocrd_dt in date
4435: ,p_pgm_id in number
4436: ,p_ptip_id in number) is
4437: select cqb.quald_bnf_flag
4438: from ben_cbr_quald_bnf cqb
4439: ,ben_cbr_per_in_ler crp
4440: ,ben_per_in_ler pil
4441: where cqb.quald_bnf_person_id = p_person_id
4442: and cqb.pgm_id = nvl(p_pgm_id,cqb.pgm_id)