APPS.BEN_CREATE_PTNL_LER_SS dependencies on BEN_LER_F

Line 58: from ben_ler_f ler

54: l_ocrd_dt_cd hr_lookups.lookup_code%TYPE; -- UTF8 varchar2(30);
55:
56: cursor get_ler is
57: select ler.ocrd_dt_det_cd
58: from ben_ler_f ler
59: where ler.business_group_id = to_number(p_business_group_id)
60: and ler.ler_id = to_number(p_ler_id)
61: and to_date(p_effective_date,hr_transaction_ss.g_date_format)
62: between ler.effective_start_date