APPS.HZ_FORMAT_PUB dependencies on HZ_STYLE_FMT_LOCALES

Line 2820: | HZ_STYLE_FMT_LOCALES.

2816: |
2817: | Styles (HZ_STYLES) can have multiple Style Formats (HZ_STYLE_FORMATS)
2818: | depending on Territory and Location ("locales"). The locales for
2819: | which a given Style Format is applicable is stored in table
2820: | HZ_STYLE_FMT_LOCALES.
2821: |
2822: | The following sequence occurs to find the matching Style Format:
2823: |
2824: | 1. Check for a match on BOTH Territory and Language Code

Line 2873: hz_style_fmt_locales hsfl,

2869: ) IS
2870: SELECT
2871: hsf.style_format_code
2872: FROM
2873: hz_style_fmt_locales hsfl,
2874: hz_style_formats_b hsf
2875: WHERE
2876: nvl(hsfl.territory_code,'X') = nvl(p_territory_code,'X')
2877: AND nvl(hsfl.language_code,'X') = nvl(p_language_code,'X')