DBA Data[Home] [Help]

APPS.PAY_IE_P45_ARCHIVE dependencies on HR_LOOKUPS

Line 341: FROM hr_lookups

337: ,p_lookup_code in varchar2 ) RETURN varchar2 IS
338:
339: CURSOR csr_get_lookup IS
340: SELECT meaning
341: FROM hr_lookups
342: WHERE lookup_type=p_lookup_type
343: AND lookup_code=p_lookup_code;
344:
345: p_lookup_meaning hr_lookups.meaning%TYPE;

Line 345: p_lookup_meaning hr_lookups.meaning%TYPE;

341: FROM hr_lookups
342: WHERE lookup_type=p_lookup_type
343: AND lookup_code=p_lookup_code;
344:
345: p_lookup_meaning hr_lookups.meaning%TYPE;
346:
347: BEGIN
348: p_lookup_meaning := NULL;
349: OPEN csr_get_lookup;