APPS.JTY_WEBADI_OTH_TERR_UPDATE_PKG dependencies on JTF_TERR_TYPE_QUAL_ALL

Line 1194: and not exists (select 1 from jtf_terr_type_qual_all jttq

1190: and jut.INTERFACE_TYPE = v_intf_type
1191: and jut.header = v_header ) sub
1192: where jqh.qualifier_num = sub.qual_num
1193: and jqh.user_sequence = sub.user_sequence
1194: and not exists (select 1 from jtf_terr_type_qual_all jttq
1195: where jttq.terr_type_id = sub.terr_type_id
1196: and jttq.qual_usg_id = jqh.qual_usg_id);
1197:
1198: TYPE Qual_Rec_Type IS RECORD