APPS.JTF_TERR_JSP_LOV_RECS_PUB dependencies on JTF_QUAL_USGS_ALL

Line 179: from jtf_qual_usgs_all

175: if l_in_filter_lov_rec.column1 = '-9001' then
176: l_jsp_lov_sql := 'select WF_NOTIFICATION.SubstituteSpecialChars(Meaning) col1_value, lookup_code col2_value from ar_lookups where lookup_type = ''HZ_PARTY_CERT_LEVEL'' ';
177: else
178: select distinct jsp_lov_sql into l_jsp_lov_sql
179: from jtf_qual_usgs_all
180: where qual_usg_id = l_in_filter_lov_rec.column1;
181:
182: end if;
183:

Line 434: FROM jtf_qual_usgs_all jqu, jtf_seeded_qual_all_b jsq,jtf_qual_type_usgs_all jqtu,

430: jqu.qual_col1_alias, jqu.display_type,
431: jsq.seeded_qual_id, null, null, null, null,
432: null, null, null, null, null,
433: null, null, null, null, null
434: FROM jtf_qual_usgs_all jqu, jtf_seeded_qual_all_b jsq,jtf_qual_type_usgs_all jqtu,
435: jtf_qual_types_all jqt ,jtf_sources_all js
436: WHERE jqu.use_in_lookup_flag = 'Y'
437: and jqu.enabled_flag = 'Y'
438: and jqtu.qual_type_id = jqt.qual_type_id