APPS.JTY_ASSIGN_BULK_PUB dependencies on JTF_TERR_QTYPE_USGS_ALL

Line 1364: FROM jtf_terr_qtype_usgs_all jtqu

1360: /* can also win depending on the date of the transaction object */
1361: IF ((p_mode = 'TOTAL') OR (p_mode = 'INCREMENTAL')) THEN
1362: SELECT COUNT(*)
1363: INTO num_of_terr
1364: FROM jtf_terr_qtype_usgs_all jtqu
1365: , jtf_terr_all jt1
1366: , jtf_qual_type_usgs jqtu
1367: WHERE jtqu.terr_id = jt1.terr_id
1368: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id