DBA Data[Home] [Help]

APPS.PAY_IE_P45_ARCHIVE dependencies on HR_LOOKUPS

Line 290: FROM hr_lookups

286: ,p_lookup_code in varchar2 ) RETURN varchar2 IS
287:
288: CURSOR csr_get_lookup IS
289: SELECT meaning
290: FROM hr_lookups
291: WHERE lookup_type=p_lookup_type
292: AND lookup_code=p_lookup_code;
293:
294: p_lookup_meaning hr_lookups.meaning%TYPE;

Line 294: p_lookup_meaning hr_lookups.meaning%TYPE;

290: FROM hr_lookups
291: WHERE lookup_type=p_lookup_type
292: AND lookup_code=p_lookup_code;
293:
294: p_lookup_meaning hr_lookups.meaning%TYPE;
295:
296: BEGIN
297: p_lookup_meaning := NULL;
298: OPEN csr_get_lookup;