APPS.HR_MX_UTILITY dependencies on HR_LOOKUPS

Line 1065: (p_lookup_type IN hr_lookups.lookup_type%TYPE

1061: --------------------------------------------------------------------------------
1062: -- FUNCTION chk_entry_in_lookup
1063: --------------------------------------------------------------------------------
1064: FUNCTION chk_entry_in_lookup
1065: (p_lookup_type IN hr_lookups.lookup_type%TYPE
1066: ,p_entry_val IN hr_lookups.meaning%TYPE
1067: ,p_effective_date IN hr_lookups.start_date_active%TYPE
1068: ,p_message OUT NOCOPY VARCHAR2) RETURN VARCHAR2 AS
1069: --

Line 1066: ,p_entry_val IN hr_lookups.meaning%TYPE

1062: -- FUNCTION chk_entry_in_lookup
1063: --------------------------------------------------------------------------------
1064: FUNCTION chk_entry_in_lookup
1065: (p_lookup_type IN hr_lookups.lookup_type%TYPE
1066: ,p_entry_val IN hr_lookups.meaning%TYPE
1067: ,p_effective_date IN hr_lookups.start_date_active%TYPE
1068: ,p_message OUT NOCOPY VARCHAR2) RETURN VARCHAR2 AS
1069: --
1070: CURSOR c_entry_in_lookup IS

Line 1067: ,p_effective_date IN hr_lookups.start_date_active%TYPE

1063: --------------------------------------------------------------------------------
1064: FUNCTION chk_entry_in_lookup
1065: (p_lookup_type IN hr_lookups.lookup_type%TYPE
1066: ,p_entry_val IN hr_lookups.meaning%TYPE
1067: ,p_effective_date IN hr_lookups.start_date_active%TYPE
1068: ,p_message OUT NOCOPY VARCHAR2) RETURN VARCHAR2 AS
1069: --
1070: CURSOR c_entry_in_lookup IS
1071: SELECT 'Y'

Line 1072: FROM hr_lookups hll

1068: ,p_message OUT NOCOPY VARCHAR2) RETURN VARCHAR2 AS
1069: --
1070: CURSOR c_entry_in_lookup IS
1071: SELECT 'Y'
1072: FROM hr_lookups hll
1073: WHERE hll.lookup_type = p_lookup_type
1074: AND hll.lookup_code = p_entry_val
1075: AND hll.enabled_flag = 'Y'
1076: AND p_effective_date BETWEEN NVL(hll.start_date_active, p_effective_date)