[Home] [Help]
1153:
1154: IF ((p_mode = 'DATE EFFECTIVE') or (p_mode = 'DEA INCREMENTAL')) THEN
1155: SELECT denorm_dea_value_table_name
1156: INTO l_table_name
1157: FROM jtf_sources_all
1158: WHERE source_id = p_source_id;
1159: ELSE
1160: SELECT denorm_value_table_name
1161: INTO l_table_name
1158: WHERE source_id = p_source_id;
1159: ELSE
1160: SELECT denorm_value_table_name
1161: INTO l_table_name
1162: FROM jtf_sources_all
1163: WHERE source_id = p_source_id;
1164: END IF; /* end IF (p_mode = 'DATE EFFECTIVE') */
1165:
1166: /* get all the qualifiers and its real time rules, used by the active territories */