1247: l_full_refresh VARCHAR2(10);
1248:
1249: BEGIN
1250:
1251: l_full_refresh := hri_oltp_conc_param.get_parameter_value
1252: (p_parameter_name => 'FULL_REFRESH',
1253: p_process_table_name => 'HRI_CS_GEO_LOCHR_CT');
1254: IF (l_full_refresh = 'Y') THEN
1255: l_start_date := hri_oltp_conc_param.get_parameter_value
1251: l_full_refresh := hri_oltp_conc_param.get_parameter_value
1252: (p_parameter_name => 'FULL_REFRESH',
1253: p_process_table_name => 'HRI_CS_GEO_LOCHR_CT');
1254: IF (l_full_refresh = 'Y') THEN
1255: l_start_date := hri_oltp_conc_param.get_parameter_value
1256: (p_parameter_name => 'FULL_REFRESH_FROM_DATE',
1257: p_process_table_name => 'HRI_CS_GEO_LOCHR_CT');
1258: ELSE
1259: -- Bug 4704157 - converted displaydt to canonical