DBA Data[Home] [Help]

APPS.HZ_DSS_VALIDATE_PKG dependencies on FND_LOOKUP_VALUES

Line 431: -- Return Y if lookup_code and lookup_type are found in FND_LOOKUP_VALUES

427: --------------------------------------
428: -- exist_in_fnd_lookups
429: --------------------------------------
430: FUNCTION exist_in_fnd_lookups
431: -- Return Y if lookup_code and lookup_type are found in FND_LOOKUP_VALUES
432: -- N otherwise
433: (p_lookup_code VARCHAR2, p_lookup_type VARCHAR2 )
434: RETURN VARCHAR2
435: IS

Line 439: from fnd_lookup_values

435: IS
436: CURSOR c0
437: IS
438: select 'Y'
439: from fnd_lookup_values
440: where lookup_type = p_lookup_type
441: and lookup_code = p_lookup_code
442: and enabled_flag = 'Y' ;
443: l_yn VARCHAR2(1);