APPS.JTF_TERR_CNR_GROUPS_PVT dependencies on JTF_TERR_QUAL_ALL

Line 603: from jtf_terr_values_all jtv, jtf_terr_qual_all jtq

599: and rownum < 2;
600:
601: CURSOR c_qualifier_defined IS
602: select 1
603: from jtf_terr_values_all jtv, jtf_terr_qual_all jtq
604: where jtq.qual_usg_id = -1102
605: and jtv.terr_qual_id = jtq.terr_qual_id
606: and jtv.low_value_char_id = p_Terr_cnr_group_rec.CNR_GROUP_ID
607: and rownum < 2;