APPS.JTF_TAE_CONTROL_PVT dependencies on JTF_TERR_QUAL_ALL

Line 135: -- jtf_terr_qual_all

131: -- territory/qualifier relations.
132: --
133: -- REQIRES / DEPENDENCIES
134: -- jtf_terr_denorm_rules_all
135: -- jtf_terr_qual_all
136: --
137: -- MODIFIES
138: -- Rows in JTF_TAE_QUAL_FACTORS/JTF_TAE_QUAL_PRODUCTS
139: --

Line 375: ,jtf_terr_qual_all jtq

371: ( SELECT ijtdr.terr_id
372: FROM jtf_terr_denorm_rules_all ijtdr
373: ,jtf_terr_qtype_usgs_all ijtqu
374: ,jtf_qual_type_usgs_all ijqtu
375: ,jtf_terr_qual_all jtq
376: WHERE ijtdr.source_id = l_source_id
377: AND ijqtu.source_id = ijtdr.source_id
378: AND ijqtu.qual_type_id = l_trans_id
379: AND ijtdr.terr_id = ijtqu.terr_id

Line 406: jtf_terr_qual_all jtq

402: jtdr.QUAL_RELATION_PRODUCT * qual_rel.qual_relation_factor
403: WHERE jtdr.terr_id IN
404: ( SELECT ijtdr.terr_id
405: FROM jtf_terr_denorm_rules_all ijtdr,
406: jtf_terr_qual_all jtq
407: WHERE ijtdr.source_id = l_source_id
408: and ijtdr.qual_type_id = -1
409: and ijtdr.related_terr_id = jtq.terr_id
410: and jtq.qual_usg_id = qual_rel.qual_usg_id )