DBA Data[Home] [Help]

APPS.BEN_COMP_OBJECT_LIST dependencies on HR_LOOKUPS

Line 619: l_meaning hr_lookups.meaning%TYPE;

615: p_business_group_id IN NUMBER
616: ,p_effective_date IN DATE) IS
617: --
618: l_package VARCHAR2(80) := g_package || '.cache_working_data';
619: l_meaning hr_lookups.meaning%TYPE;
620: l_lookup_code hr_lookups.lookup_code%TYPE;
621: l_ler_id ben_ler_f.ler_id%TYPE;
622: --
623: CURSOR c_comp_object_meanings IS

Line 620: l_lookup_code hr_lookups.lookup_code%TYPE;

616: ,p_effective_date IN DATE) IS
617: --
618: l_package VARCHAR2(80) := g_package || '.cache_working_data';
619: l_meaning hr_lookups.meaning%TYPE;
620: l_lookup_code hr_lookups.lookup_code%TYPE;
621: l_ler_id ben_ler_f.ler_id%TYPE;
622: --
623: CURSOR c_comp_object_meanings IS
624: SELECT hr.meaning

Line 626: FROM hr_lookups hr

622: --
623: CURSOR c_comp_object_meanings IS
624: SELECT hr.meaning
625: ,hr.lookup_code
626: FROM hr_lookups hr
627: WHERE hr.lookup_type = 'BEN_COMP_OBJ'
628: AND hr.enabled_flag = 'Y'
629: AND p_effective_date BETWEEN NVL(hr.start_date_active
630: ,p_effective_date)