APPS.BEN_EVALUATE_RATE_PROFILES dependencies on BEN_CBR_PER_IN_LER

Line 3809: ,ben_cbr_per_in_ler crp

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

Line 3829: ,ben_cbr_per_in_ler crp

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

Line 3848: from ben_cbr_per_in_ler crp

3844: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
3845: --
3846: cursor c_get_dsblity_evt(p_cbr_quald_bnf_id number) is
3847: select null
3848: from ben_cbr_per_in_ler crp
3849: , ben_ler_f ler
3850: , ben_per_in_ler pil
3851: where crp.cbr_quald_bnf_id = p_cbr_quald_bnf_id
3852: and crp.per_in_ler_id = pil.per_in_ler_id

Line 3863: from ben_cbr_per_in_ler crp2

3859: and ler.business_group_id = p_business_group_id
3860: and ler.business_group_id = pil.business_group_id
3861: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
3862: and crp.cnt_num = (select max(cnt_num)
3863: from ben_cbr_per_in_ler crp2
3864: ,ben_per_in_ler pil2
3865: where crp2.cbr_quald_bnf_id = p_cbr_quald_bnf_id
3866: and crp2.per_in_ler_id = pil2.per_in_ler_id
3867: and pil2.per_in_ler_stat_cd not in ('VOIDD','BCKDT')

Line 4439: ,ben_cbr_per_in_ler crp

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