APPS.JTY_TERR_ENGINE_GEN_PVT dependencies on JTF_QUAL_TYPE_USGS_ALL

Line 343: FROM jtf_qual_type_usgs_all

339: AS
340:
341: CURSOR c_trans_types (cl_source_id NUMBER) IS
342: SELECT qual_type_id
343: FROM jtf_qual_type_usgs_all
344: WHERE source_id = cl_source_id
345: AND qual_type_id <> -1001;
346:
347: CURSOR c_qual_rel_sets(cl_source_id number, cl_qual_type_id number) is

Line 350: ,jtf_qual_type_usgs_all jqtu

346:
347: CURSOR c_qual_rel_sets(cl_source_id number, cl_qual_type_id number) is
348: select distinct jtqu.qual_relation_product
349: from jtf_terr_qtype_usgs_all jtqu
350: ,jtf_qual_type_usgs_all jqtu
351: where jqtu.source_id = cl_source_id
352: and jqtu.qual_type_id = cl_qual_type_id
353: and jtqu.qual_type_usg_id = jqtu.qual_type_usg_id
354: and jtqu.qual_relation_product <> 1

Line 364: ,jtf_qual_type_usgs_all jqtu

360:
361: CURSOR c_dea_qual_rel_sets(cl_source_id number, cl_qual_type_id number) is
362: select distinct jtqu.qual_relation_product
363: from jtf_terr_qtype_usgs_all jtqu
364: ,jtf_qual_type_usgs_all jqtu
365: where jqtu.source_id = cl_source_id
366: and jqtu.qual_type_id = cl_qual_type_id
367: and jtqu.qual_type_usg_id = jqtu.qual_type_usg_id
368: and jtqu.qual_relation_product <> 1

Line 375: TYPE l_qual_type_id_tbl_type IS TABLE OF jtf_qual_type_usgs_all.qual_type_id%TYPE;

371: from jty_denorm_dea_rules_all jtdr
372: where jtdr.terr_id = jtqu.terr_id
373: and jtqu.terr_id = jtdr.related_terr_id );
374:
375: TYPE l_qual_type_id_tbl_type IS TABLE OF jtf_qual_type_usgs_all.qual_type_id%TYPE;
376:
377: l_qual_type_id_tbl l_qual_type_id_tbl_type;
378: l_qual_prd_tbl qual_prd_tbl_type;
379:

Line 472: jtf_qual_type_usgs_all b,

468: BEGIN
469: SELECT a.qual_relation_product
470: INTO l_qual_relation_product
471: FROM jtf_terr_qtype_usgs_all a,
472: jtf_qual_type_usgs_all b,
473: jtf_terr_all c
474: WHERE a.qual_type_usg_id = b.qual_type_usg_id
475: AND b.source_id = p_source_id
476: AND b.qual_type_id = l_qual_type_id_tbl(i)