APPS.HZ_NAME_ADDRESS_FMT_VALIDATE dependencies on HZ_STYLE_FORMATS_TL

Line 502: l_style_format_name HZ_STYLE_FORMATS_TL.style_format_name%TYPE;

498: l_dummy VARCHAR2(1);
499: l_style_format_code HZ_STYLE_FORMATS_B.style_format_code%TYPE;
500: l_style_code HZ_STYLE_FORMATS_B.style_code%TYPE;
501: l_default_flag HZ_STYLE_FORMATS_B.default_flag%TYPE;
502: l_style_format_name HZ_STYLE_FORMATS_TL.style_format_name%TYPE;
503: l_debug_prefix VARCHAR2(30) := '';
504:
505: BEGIN
506:

Line 527: FROM HZ_STYLE_FORMATS_B b , HZ_STYLE_FORMATS_TL t

523: INTO l_style_format_code,
524: l_style_code,
525: l_default_flag,
526: l_style_format_name
527: FROM HZ_STYLE_FORMATS_B b , HZ_STYLE_FORMATS_TL t
528: WHERE b.ROWID = p_rowid
529: AND t.style_format_code = b.style_format_code
530: AND t.language = userenv('LANG');
531:

Line 782: from HZ_STYLE_FORMATS_TL

778: p_style_format_rec.style_format_name <> l_style_format_name)
779: THEN
780: BEGIN
781: select 'Y' into l_dummy
782: from HZ_STYLE_FORMATS_TL
783: where style_format_name = p_style_format_rec.style_format_name
784: and language = userenv('LANG');
785:
786: FND_MESSAGE.SET_NAME('AR', 'HZ_STYLE_FMT_NAME_DUP');