APPS.JTF_TERR_DENORM_RULES_PVT dependencies on JTF_QUAL_TYPE_DENORM_V

Line 322: , jtf_qual_type_denorm_v v

318: INTO l_num_qual_tbl(i)
319: FROM jtf_terr_qual_all jtq
320: , jtf_qual_usgs_all jqu
321: , jtf_qual_type_usgs jqtu
322: , jtf_qual_type_denorm_v v
323: WHERE jtq.qual_usg_id = jqu.qual_usg_id
324: AND ( (jtq.org_id = jqu.org_id) OR
325: (jtq.org_id IS NULL AND jqu.org_ID IS NULL)
326: )

Line 661: FROM jtf_qual_type_denorm_v

657: AND i2.org_id = -3113
658: AND i2.qual_type_usg_id = i3.qual_type_usg_id
659: AND i3.source_id = p_source_id
660: AND i3.qual_type_id in (SELECT related_id
661: FROM jtf_qual_type_denorm_v
662: WHERE qual_type_id = p_qual_type_id) );
663:
664: END IF;
665: