[Home] [Help]
116: WHERE source_id = p_source_id
117: AND trans_object_type_id = p_trans_id
118: AND relation_product not in (
119: SELECT qual_relation_product
120: FROM jtf_terr_qtype_usgs_all a,
121: jtf_qual_type_usgs_all b
122: WHERE a.qual_type_usg_id = b.qual_type_usg_id
123: AND b.source_id = p_source_id
124: AND b.qual_type_id = p_trans_id)