APPS.PAY_KR_NPA_PKG dependencies on HR_LOOKUPS

Line 390: CURSOR csr_hr_lookups

386: RETURN VARCHAR2
387: IS
388: l_meaning VARCHAR2(80);
389: no_lookup EXCEPTION;
390: CURSOR csr_hr_lookups
391: IS
392: SELECT meaning
393: FROM hr_lookups
394: WHERE lookup_type = p_lookup_type

Line 393: FROM hr_lookups

389: no_lookup EXCEPTION;
390: CURSOR csr_hr_lookups
391: IS
392: SELECT meaning
393: FROM hr_lookups
394: WHERE lookup_type = p_lookup_type
395: AND lookup_code = p_lookup_code;
396: BEGIN
397: OPEN csr_hr_lookups ;

Line 397: OPEN csr_hr_lookups ;

393: FROM hr_lookups
394: WHERE lookup_type = p_lookup_type
395: AND lookup_code = p_lookup_code;
396: BEGIN
397: OPEN csr_hr_lookups ;
398: FETCH csr_hr_lookups INTO l_meaning;
399: CLOSE csr_hr_lookups ;
400:
401: IF l_meaning IS NOT NULL THEN

Line 398: FETCH csr_hr_lookups INTO l_meaning;

394: WHERE lookup_type = p_lookup_type
395: AND lookup_code = p_lookup_code;
396: BEGIN
397: OPEN csr_hr_lookups ;
398: FETCH csr_hr_lookups INTO l_meaning;
399: CLOSE csr_hr_lookups ;
400:
401: IF l_meaning IS NOT NULL THEN
402: RETURN l_meaning;

Line 399: CLOSE csr_hr_lookups ;

395: AND lookup_code = p_lookup_code;
396: BEGIN
397: OPEN csr_hr_lookups ;
398: FETCH csr_hr_lookups INTO l_meaning;
399: CLOSE csr_hr_lookups ;
400:
401: IF l_meaning IS NOT NULL THEN
402: RETURN l_meaning;
403: ELSE