153: ----------------------------------------------------------------------------
154: -- CHK_ENTRY_IN_LOOKUP
155: ----------------------------------------------------------------------------
156: FUNCTION chk_entry_in_lookup (
157: p_lookup_type IN hr_leg_lookups.lookup_type%TYPE
158: , p_entry_val IN hr_leg_lookups.meaning%TYPE
159: , p_effective_date IN hr_leg_lookups.start_date_active%TYPE
160: , p_message OUT NOCOPY VARCHAR2
161: ) RETURN VARCHAR2
154: -- CHK_ENTRY_IN_LOOKUP
155: ----------------------------------------------------------------------------
156: FUNCTION chk_entry_in_lookup (
157: p_lookup_type IN hr_leg_lookups.lookup_type%TYPE
158: , p_entry_val IN hr_leg_lookups.meaning%TYPE
159: , p_effective_date IN hr_leg_lookups.start_date_active%TYPE
160: , p_message OUT NOCOPY VARCHAR2
161: ) RETURN VARCHAR2
162: AS
155: ----------------------------------------------------------------------------
156: FUNCTION chk_entry_in_lookup (
157: p_lookup_type IN hr_leg_lookups.lookup_type%TYPE
158: , p_entry_val IN hr_leg_lookups.meaning%TYPE
159: , p_effective_date IN hr_leg_lookups.start_date_active%TYPE
160: , p_message OUT NOCOPY VARCHAR2
161: ) RETURN VARCHAR2
162: AS
163:
162: AS
163:
164: CURSOR c_entry_in_lookup IS
165: select 'X'
166: from hr_leg_lookups hll
167: where hll.LOOKUP_TYPE = p_lookup_type
168: and hll.meaning = p_entry_val
169: and hll.enabled_flag = 'Y'
170: and p_effective_date between nvl(hll.start_date_active, p_effective_date)
170: and p_effective_date between nvl(hll.start_date_active, p_effective_date)
171: and nvl(hll.end_date_active, p_effective_date);
172: CURSOR c_lookup_values IS
173: select hll.meaning
174: from hr_leg_lookups hll
175: where hll.LOOKUP_TYPE = p_lookup_type
176: and hll.enabled_flag = 'Y'
177: and p_effective_date between nvl(hll.start_date_active, p_effective_date)
178: and nvl(hll.end_date_active, p_effective_date)