793: FROM hr_lookups
794: WHERE lookup_type = p_lookup_type
795: AND lookup_code = p_lookup_code
796: AND enabled_flag = 'Y'
797: AND sysdate between NVL(start_date_active, hr_api.g_sot)
798: AND NVL(end_date_active, hr_api.g_eot);
799: --
800: CURSOR csr_fnd_lookup
801: ( p_lookup_type VARCHAR2
794: WHERE lookup_type = p_lookup_type
795: AND lookup_code = p_lookup_code
796: AND enabled_flag = 'Y'
797: AND sysdate between NVL(start_date_active, hr_api.g_sot)
798: AND NVL(end_date_active, hr_api.g_eot);
799: --
800: CURSOR csr_fnd_lookup
801: ( p_lookup_type VARCHAR2
802: , p_lookup_code VARCHAR2
806: FROM fnd_lookups
807: WHERE lookup_type = p_lookup_type
808: AND lookup_code = p_lookup_code
809: AND enabled_flag = 'Y'
810: AND sysdate between NVL(start_date_active, hr_api.g_sot)
811: AND NVL(end_date_active, hr_api.g_eot);
812: BEGIN
813: g_debug := hr_utility.debug_enabled;
814: IF g_debug THEN
807: WHERE lookup_type = p_lookup_type
808: AND lookup_code = p_lookup_code
809: AND enabled_flag = 'Y'
810: AND sysdate between NVL(start_date_active, hr_api.g_sot)
811: AND NVL(end_date_active, hr_api.g_eot);
812: BEGIN
813: g_debug := hr_utility.debug_enabled;
814: IF g_debug THEN
815: l_proc := g_package || ' Get_lookup_Meaning';
873: SELECT lookup_type, lookup_code, meaning
874: FROM hr_lookups
875: WHERE lookup_type = p_lookup_type
876: AND enabled_flag = 'Y'
877: AND sysdate between NVL(start_date_active, hr_api.g_sot)
878: AND NVL(end_date_active, hr_api.g_eot)
879: ORDER by meaning;
880:
881: --
874: FROM hr_lookups
875: WHERE lookup_type = p_lookup_type
876: AND enabled_flag = 'Y'
877: AND sysdate between NVL(start_date_active, hr_api.g_sot)
878: AND NVL(end_date_active, hr_api.g_eot)
879: ORDER by meaning;
880:
881: --
882: CURSOR csr_fnd_lookup
886: SELECT lookup_type, lookup_code, meaning
887: FROM fnd_lookups
888: WHERE lookup_type = p_lookup_type
889: AND enabled_flag = 'Y'
890: AND sysdate between NVL(start_date_active, hr_api.g_sot)
891: AND NVL(end_date_active, hr_api.g_eot)
892: ORDER by meaning;
893:
894: BEGIN
887: FROM fnd_lookups
888: WHERE lookup_type = p_lookup_type
889: AND enabled_flag = 'Y'
890: AND sysdate between NVL(start_date_active, hr_api.g_sot)
891: AND NVL(end_date_active, hr_api.g_eot)
892: ORDER by meaning;
893:
894: BEGIN
895: g_debug := hr_utility.debug_enabled;