APPS.JTY_WEBADI_OTH_TERR_UPDATE_PKG dependencies on JTF_TERR_TYPE_QUAL_ALL

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

511: and jut.INTERFACE_TYPE = v_intf_type
512: and jut.header = v_header) sub
513: where jqh.qualifier_num = sub.qual_num
514: and jqh.user_sequence = sub.user_sequence
515: and not exists (select 1 from jtf_terr_type_qual_all jttq
516: where jttq.terr_type_id = sub.terr_type_id
517: and jttq.qual_usg_id = jqh.qual_usg_id);
518:
519: TYPE Qual_Rec_Type IS RECORD