APPS.JTY_TERR_DENORM_RULES_PVT dependencies on JTF_SOURCES_ALL

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

992: 'DENORM_TERR_DEA_VALUES_ID');
993:
994: TYPE l_qtype_terr_id_tbl_type IS TABLE OF jtf_terr_all.terr_id%TYPE;
995: TYPE l_qtype_trans_id_tbl_type IS TABLE OF jtf_qual_types_all.qual_type_id%TYPE;
996: TYPE l_qtype_source_id_tbl_type IS TABLE OF jtf_sources_all.source_id%TYPE;
997: TYPE l_qtype_num_qual_tbl_type IS TABLE OF jtf_terr_qtype_usgs_all.num_qual%TYPE;
998: TYPE l_qtype_qual_prd_tbl_type IS TABLE OF jtf_terr_qtype_usgs_all.qual_relation_product%TYPE;
999:
1000: TYPE l_qual_type_id_tbl_type IS TABLE OF jtf_qual_type_usgs_all.qual_type_id%TYPE;

Line 2300: FROM jtf_sources_all

2296:
2297: IF (p_mode = 'DATE EFFECTIVE') THEN
2298: SELECT denorm_dea_value_table_name
2299: INTO l_table_name
2300: FROM jtf_sources_all
2301: WHERE source_id = p_source_id;
2302: ELSE
2303: SELECT denorm_value_table_name
2304: INTO l_table_name

Line 2305: FROM jtf_sources_all

2301: WHERE source_id = p_source_id;
2302: ELSE
2303: SELECT denorm_value_table_name
2304: INTO l_table_name
2305: FROM jtf_sources_all
2306: WHERE source_id = p_source_id;
2307: END IF; /* end IF (p_mode = 'DATE EFFECTIVE') */
2308:
2309: /* delete the old records from denormalized tables */