APPS.BEN_DETERMINE_COVERAGE dependencies on BEN_LER_F

Line 722: from ben_ler_f ler

718: /* End of Changes for WWBUG: 2157614 */
719: --Unrestricted enh
720: cursor c_unrest(p_ler_id number) is
721: select 'Y'
722: from ben_ler_f ler
723: where ler.typ_cd = 'SCHEDDU'
724: and ler.ler_id = p_ler_id
725: and p_effective_date between ler.effective_start_date
726: and ler.effective_end_date;

Line 735: ben_ler_f ler

731: SELECT pen.prtt_enrt_rslt_id,
732: pen.bnft_amt,
733: pen.bnft_ordr_num
734: FROM ben_prtt_enrt_rslt_f pen,
735: ben_ler_f ler
736: WHERE pen.ler_id = ler.ler_id
737: AND pen.person_id = p_person_id
738: AND pen.business_group_id = p_business_group_id
739: AND pen.prtt_enrt_rslt_stat_cd IS NULL

Line 1966: from ben_ler_f ler

1962: l_tot_val number;
1963: --Unrestricted enh
1964: cursor c_unrest(p_ler_id number) is
1965: select 'Y'
1966: from ben_ler_f ler
1967: where ler.typ_cd = 'SCHEDDU'
1968: and ler.ler_id = p_ler_id
1969: and p_effective_date between ler.effective_start_date
1970: and ler.effective_end_date;

Line 2034: ben_ler_f ler

2030:
2031: cursor c_get_prev_pil(p_person_id number) is
2032: SELECT pil.*
2033: FROM ben_per_in_ler pil,
2034: ben_ler_f ler
2035: WHERE pil.person_id = p_person_id
2036: AND pil.ler_id = ler.ler_id
2037: AND ler.business_group_id = pil.business_group_id
2038: AND ler.typ_cd NOT IN ('IREC','GSP','COMP','ABS','SCHEDDU')