APPS.JTY_TERR_DENORM_RULES_PVT dependencies on JTF_SOURCES_ALL

Line 1093: TYPE l_qtype_source_id_tbl_type IS TABLE OF jtf_sources_all.source_id%TYPE;

1089:
1090:
1091: TYPE l_qtype_terr_id_tbl_type IS TABLE OF jtf_terr_all.terr_id%TYPE;
1092: TYPE l_qtype_trans_id_tbl_type IS TABLE OF jtf_qual_types_all.qual_type_id%TYPE;
1093: TYPE l_qtype_source_id_tbl_type IS TABLE OF jtf_sources_all.source_id%TYPE;
1094: TYPE l_qtype_num_qual_tbl_type IS TABLE OF jtf_terr_qtype_usgs_all.num_qual%TYPE;
1095: TYPE l_qtype_qual_prd_tbl_type IS TABLE OF jtf_terr_qtype_usgs_all.qual_relation_product%TYPE;
1096:
1097: TYPE l_qual_type_id_tbl_type IS TABLE OF jtf_qual_type_usgs_all.qual_type_id%TYPE;

Line 2426: FROM jtf_sources_all

2422:
2423: IF (p_mode = 'DATE EFFECTIVE') THEN
2424: SELECT denorm_dea_value_table_name
2425: INTO l_table_name
2426: FROM jtf_sources_all
2427: WHERE source_id = p_source_id;
2428: ELSIF (p_mode = 'DEA INCREMENTAL') THEN
2429: SELECT denorm_dea_value_table_name
2430: INTO l_table_name

Line 2431: FROM jtf_sources_all

2427: WHERE source_id = p_source_id;
2428: ELSIF (p_mode = 'DEA INCREMENTAL') THEN
2429: SELECT denorm_dea_value_table_name
2430: INTO l_table_name
2431: FROM jtf_sources_all
2432: WHERE source_id = p_source_id;
2433: ELSE
2434: SELECT denorm_value_table_name
2435: INTO l_table_name

Line 2436: FROM jtf_sources_all

2432: WHERE source_id = p_source_id;
2433: ELSE
2434: SELECT denorm_value_table_name
2435: INTO l_table_name
2436: FROM jtf_sources_all
2437: WHERE source_id = p_source_id;
2438: END IF; /* end IF (p_mode = 'DATE EFFECTIVE') */
2439:
2440: /* delete the old records from denormalized tables */