APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_LER_F

Line 641: FROM ben_ler_f ler

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

Line 1831: FROM ben_ler_f ler

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

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

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

Line 10749: from ben_ler_f

10745: and effective_end_date;
10746: --
10747: cursor c_get_gsp_ler(cv_effective_date in date ) is
10748: select ler_id, name
10749: from ben_ler_f
10750: where typ_cd = 'GSP'
10751: and business_group_id = p_business_group_id
10752: and cv_effective_date between effective_start_date
10753: and effective_end_date;