APPS.HZ_NAME_ADDRESS_FMT_VALIDATE dependencies on HZ_STYLES_TL

Line 223: l_style_name HZ_STYLES_TL.style_name%TYPE;

219: ) IS
220:
221: l_dummy VARCHAR2(1);
222: l_style_code HZ_STYLES_B.style_code%TYPE;
223: l_style_name HZ_STYLES_TL.style_name%TYPE;
224: l_database_object_name HZ_STYLES_B.database_object_name%TYPE;
225: l_debug_prefix VARCHAR2(30) := '';
226:
227: BEGIN

Line 246: FROM HZ_STYLES_B b , HZ_STYLES_TL t

242: b.database_object_name
243: INTO l_style_code,
244: l_style_name,
245: l_database_object_name
246: FROM HZ_STYLES_B b , HZ_STYLES_TL t
247: WHERE b.ROWID = p_rowid
248: AND t.style_code = b.style_code
249: AND t.language = userenv('LANG');
250:

Line 430: from HZ_STYLES_TL

426: p_style_rec.style_name <> l_style_name)
427: THEN
428: BEGIN
429: select 'Y' into l_dummy
430: from HZ_STYLES_TL
431: where style_name = p_style_rec.style_name
432: and language = userenv('LANG');
433:
434: FND_MESSAGE.SET_NAME('AR', 'HZ_STYLE_NAME_DUP');