APPS.HZ_FORMAT_PUB dependencies on HZ_STYLE_FMT_VARIATIONS

Line 1629: l_sql_string := 'select count(1) from HZ_STYLE_FMT_VARIATIONS ' ||

1625: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT: returned l_variation_num: ' || l_variation_num);
1626: end if;
1627:
1628: if(p_country = 'US') then
1629: l_sql_string := 'select count(1) from HZ_STYLE_FMT_VARIATIONS ' ||
1630: 'where STYLE_FORMAT_CODE = :1 ' ||
1631: 'and VARIATION_NUMBER = 2 ' ||
1632: 'and (SYSDATE > start_date_active ' ||
1633: 'and SYSDATE <= NVL(end_date_active, SYSDATE))';

Line 4108: hz_style_fmt_variations

4104: SELECT
4105: variation_number,
4106: selection_condition
4107: FROM
4108: hz_style_fmt_variations
4109: WHERE
4110: style_format_code = p_style_format_code
4111: AND (SYSDATE BETWEEN start_date_active
4112: AND NVL(end_date_active, to_date('12/31/4712','MM/DD/YYYY')))

Line 4186: hz_style_fmt_variations

4182: SELECT
4183: variation_number,
4184: selection_condition
4185: FROM
4186: hz_style_fmt_variations
4187: WHERE
4188: style_format_code = p_style_format_code
4189: AND (SYSDATE BETWEEN start_date_active
4190: AND NVL(end_date_active, to_date('12/31/4712','MM/DD/YYYY')))