APPS.GHR_FORMULA_FUNCTIONS dependencies on BEN_LER_F

Line 1483: v_ler_name ben_ler_f.name%type;

1479: RETURN VARCHAR2 Is
1480:
1481: l_proc_name VARCHAR2(100);
1482: v_eligible VARCHAR2(1);
1483: v_ler_name ben_ler_f.name%type;
1484: v_opt_name ben_opt_f.name%type;
1485: v_pl_name ben_pl_f.name%type;
1486: v_person_id per_all_people_f.person_id%type;
1487: v_coe_date Date;

Line 1497: from ben_ler_f

1493: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1494:
1495: Cursor c_get_ler_name is
1496: select name
1497: from ben_ler_f
1498: where ler_id = p_ler_id
1499: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1500:
1501: Cursor c_get_option_name is

Line 2171: from ben_ler_f

2167: and trunc(p_effective_date) between effective_start_date and effective_end_date;
2168:
2169: Cursor c_get_ler_name(p_ler_id in number) is
2170: select name
2171: from ben_ler_f
2172: where ler_id = p_ler_id
2173: and trunc(p_effective_date) between effective_start_date and effective_end_date;
2174:
2175: l_fegli_code ghr_pa_requests.fegli%type;

Line 2180: l_ler_name ben_ler_f.name%type;

2176: l_person_id per_all_assignments_f.person_id%type;
2177: l_payroll_id per_all_assignments_f.payroll_id%type;
2178: l_enrt_cvg_st_dt ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%type;
2179: l_option_id ben_opt_f.opt_id%type;
2180: l_ler_name ben_ler_f.name%type;
2181: l_ler_id ben_ler_f.ler_id%type;
2182: l_fegli_event_code varchar2(3);
2183:
2184: BEGIN

Line 2181: l_ler_id ben_ler_f.ler_id%type;

2177: l_payroll_id per_all_assignments_f.payroll_id%type;
2178: l_enrt_cvg_st_dt ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%type;
2179: l_option_id ben_opt_f.opt_id%type;
2180: l_ler_name ben_ler_f.name%type;
2181: l_ler_id ben_ler_f.ler_id%type;
2182: l_fegli_event_code varchar2(3);
2183:
2184: BEGIN
2185:

Line 2258: v_ler_name ben_ler_f.name%type;

2254: v_hire_date Date;
2255: v_period_st_date Date;
2256: v_person_id per_all_people_f.person_id%type;
2257: v_payroll_id per_all_assignments_f.payroll_id%type;
2258: v_ler_name ben_ler_f.name%type;
2259: v_effective_st_dt Date;
2260:
2261:
2262:

Line 2274: from ben_ler_f

2270:
2271: --get Life Event Name
2272: Cursor c_get_ler_name is
2273: select name
2274: from ben_ler_f
2275: where ler_id = p_ler_id
2276: and trunc(p_effective_date) between effective_start_date and effective_end_date;
2277:
2278: