DBA Data[Home] [Help]

APPS.BEN_COMP_OBJECT_LIST dependencies on HR_LOOKUPS

Line 609: l_meaning hr_lookups.meaning%TYPE;

605: p_business_group_id IN NUMBER
606: ,p_effective_date IN DATE) IS
607: --
608: l_package VARCHAR2(80) := g_package || '.cache_working_data';
609: l_meaning hr_lookups.meaning%TYPE;
610: l_lookup_code hr_lookups.lookup_code%TYPE;
611: l_ler_id ben_ler_f.ler_id%TYPE;
612: --
613: CURSOR c_comp_object_meanings IS

Line 610: l_lookup_code hr_lookups.lookup_code%TYPE;

606: ,p_effective_date IN DATE) IS
607: --
608: l_package VARCHAR2(80) := g_package || '.cache_working_data';
609: l_meaning hr_lookups.meaning%TYPE;
610: l_lookup_code hr_lookups.lookup_code%TYPE;
611: l_ler_id ben_ler_f.ler_id%TYPE;
612: --
613: CURSOR c_comp_object_meanings IS
614: SELECT hr.meaning

Line 616: FROM hr_lookups hr

612: --
613: CURSOR c_comp_object_meanings IS
614: SELECT hr.meaning
615: ,hr.lookup_code
616: FROM hr_lookups hr
617: WHERE hr.lookup_type = 'BEN_COMP_OBJ'
618: AND hr.enabled_flag = 'Y'
619: AND p_effective_date BETWEEN NVL(hr.start_date_active
620: ,p_effective_date)