APPS.JTY_ASSIGN_BULK_PUB dependencies on JTF_TERR_QTYPE_USGS_ALL

Line 1278: FROM jtf_terr_qtype_usgs_all jtqu

1274: /* can also win depending on the date of the transaction object */
1275: IF ((p_mode = 'TOTAL') OR (p_mode = 'INCREMENTAL')) THEN
1276: SELECT COUNT(*)
1277: INTO num_of_terr
1278: FROM jtf_terr_qtype_usgs_all jtqu
1279: , jtf_terr_all jt1
1280: , jtf_qual_type_usgs jqtu
1281: WHERE jtqu.terr_id = jt1.terr_id
1282: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id