APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_LER_F

Line 642: FROM ben_ler_f ler

638: --
639: CURSOR c1 IS
640: SELECT ler.name,
641: ler.ptnl_ler_trtmt_cd
642: FROM ben_ler_f ler
643: WHERE ler.ler_id = p_ler_id
644: AND ler.business_group_id = p_business_group_id
645: AND p_effective_date BETWEEN ler.effective_start_date
646: AND ler.effective_end_date;

Line 1832: FROM ben_ler_f ler

1828: --
1829: CURSOR c1 IS
1830: SELECT ler.name,
1831: ler.ptnl_ler_trtmt_cd
1832: FROM ben_ler_f ler
1833: WHERE ler.ler_id = p_ler_id
1834: AND ler.business_group_id = p_business_group_id
1835: AND p_effective_date BETWEEN ler.effective_start_date
1836: AND ler.effective_end_date;

Line 10190: FROM ben_cbr_per_in_ler crp, ben_ler_f ler, ben_per_in_ler pil

10186: --
10187: CURSOR c_get_dsblity_evt(
10188: p_cbr_quald_bnf_id NUMBER) IS
10189: SELECT crp.*
10190: FROM ben_cbr_per_in_ler crp, ben_ler_f ler, ben_per_in_ler pil
10191: WHERE crp.cbr_quald_bnf_id = p_cbr_quald_bnf_id
10192: AND crp.per_in_ler_id = pil.per_in_ler_id
10193: AND pil.ler_id = ler.ler_id
10194: AND ler.typ_cd = 'DSBLTY'

Line 10289: ,ben_ler_f ler

10285: )
10286: IS
10287: SELECT ler.*, pil.lf_evt_ocrd_dt
10288: FROM ben_per_in_ler pil
10289: ,ben_ler_f ler
10290: WHERE pil.ler_id = ler.ler_id
10291: AND pil.business_group_id = p_business_group_id
10292: AND ler.name = 'Assistance Eligible Individual'
10293: AND pil.per_in_ler_stat_cd NOT IN ('VOIDD', 'BCKDT')

Line 10822: from ben_ler_f

10818: and effective_end_date;
10819: --
10820: cursor c_get_gsp_ler(cv_effective_date in date ) is
10821: select ler_id, name
10822: from ben_ler_f
10823: where typ_cd = 'GSP'
10824: and business_group_id = p_business_group_id
10825: and cv_effective_date between effective_start_date
10826: and effective_end_date;