DBA Data[Home] [Help]

APPS.GHR_FORMULA_FUNCTIONS dependencies on BEN_LER_F

Line 1479: v_ler_name ben_ler_f.name%type;

1475: RETURN VARCHAR2 Is
1476:
1477: l_proc_name VARCHAR2(100);
1478: v_eligible VARCHAR2(1);
1479: v_ler_name ben_ler_f.name%type;
1480: v_opt_name ben_opt_f.name%type;
1481: v_pl_name ben_pl_f.name%type;
1482: v_person_id per_all_people_f.person_id%type;
1483: v_coe_date Date;

Line 1493: from ben_ler_f

1489: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1490:
1491: Cursor c_get_ler_name is
1492: select name
1493: from ben_ler_f
1494: where ler_id = p_ler_id
1495: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1496:
1497: Cursor c_get_option_name is