APPS.BEN_EVALUATE_RATE_PROFILES dependencies on BEN_CBR_PER_IN_LER

Line 3803: ,ben_cbr_per_in_ler crp

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'
3807: and nvl(p_lf_evt_ocrd_dt,p_effective_date)

Line 3823: ,ben_cbr_per_in_ler crp

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'
3827: and nvl(p_lf_evt_ocrd_dt,p_effective_date)

Line 3842: from ben_cbr_per_in_ler crp

3838: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
3839: --
3840: cursor c_get_dsblity_evt(p_cbr_quald_bnf_id number) is
3841: select null
3842: from ben_cbr_per_in_ler crp
3843: , ben_ler_f ler
3844: , ben_per_in_ler pil
3845: where crp.cbr_quald_bnf_id = p_cbr_quald_bnf_id
3846: and crp.per_in_ler_id = pil.per_in_ler_id

Line 3857: from ben_cbr_per_in_ler crp2

3853: and ler.business_group_id = p_business_group_id
3854: and ler.business_group_id = pil.business_group_id
3855: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
3856: and crp.cnt_num = (select max(cnt_num)
3857: from ben_cbr_per_in_ler crp2
3858: ,ben_per_in_ler pil2
3859: where crp2.cbr_quald_bnf_id = p_cbr_quald_bnf_id
3860: and crp2.per_in_ler_id = pil2.per_in_ler_id
3861: and pil2.per_in_ler_stat_cd not in ('VOIDD','BCKDT')

Line 4386: ,ben_cbr_per_in_ler crp

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)
4390: and nvl(cqb.ptip_id,-1) = nvl(p_ptip_id, -1)