APPS.HR_MX_UTILITY dependencies on HR_LOOKUPS

Line 1077: (p_lookup_type IN hr_lookups.lookup_type%TYPE

1073: --------------------------------------------------------------------------------
1074: -- FUNCTION chk_entry_in_lookup
1075: --------------------------------------------------------------------------------
1076: FUNCTION chk_entry_in_lookup
1077: (p_lookup_type IN hr_lookups.lookup_type%TYPE
1078: ,p_entry_val IN hr_lookups.meaning%TYPE
1079: ,p_effective_date IN hr_lookups.start_date_active%TYPE
1080: ,p_message OUT NOCOPY VARCHAR2) RETURN VARCHAR2 AS
1081: --

Line 1078: ,p_entry_val IN hr_lookups.meaning%TYPE

1074: -- FUNCTION chk_entry_in_lookup
1075: --------------------------------------------------------------------------------
1076: FUNCTION chk_entry_in_lookup
1077: (p_lookup_type IN hr_lookups.lookup_type%TYPE
1078: ,p_entry_val IN hr_lookups.meaning%TYPE
1079: ,p_effective_date IN hr_lookups.start_date_active%TYPE
1080: ,p_message OUT NOCOPY VARCHAR2) RETURN VARCHAR2 AS
1081: --
1082: CURSOR c_entry_in_lookup IS

Line 1079: ,p_effective_date IN hr_lookups.start_date_active%TYPE

1075: --------------------------------------------------------------------------------
1076: FUNCTION chk_entry_in_lookup
1077: (p_lookup_type IN hr_lookups.lookup_type%TYPE
1078: ,p_entry_val IN hr_lookups.meaning%TYPE
1079: ,p_effective_date IN hr_lookups.start_date_active%TYPE
1080: ,p_message OUT NOCOPY VARCHAR2) RETURN VARCHAR2 AS
1081: --
1082: CURSOR c_entry_in_lookup IS
1083: SELECT 'Y'

Line 1084: FROM hr_lookups hll

1080: ,p_message OUT NOCOPY VARCHAR2) RETURN VARCHAR2 AS
1081: --
1082: CURSOR c_entry_in_lookup IS
1083: SELECT 'Y'
1084: FROM hr_lookups hll
1085: WHERE hll.lookup_type = p_lookup_type
1086: AND hll.lookup_code = p_entry_val
1087: AND hll.enabled_flag = 'Y'
1088: AND p_effective_date BETWEEN NVL(hll.start_date_active, p_effective_date)