DBA Data[Home] [Help]

APPS.JTF_TAE_ASSIGN_PUB dependencies on JTF_TERR_QTYPE_USGS_ALL

Line 411: FROM jtf_terr_qtype_usgs_all jtqu

407:
408: -- Check for territories for this Usage/Transaction Type
409: SELECT COUNT(*)
410: INTO num_of_terr
411: FROM jtf_terr_qtype_usgs_all jtqu
412: , jtf_terr_usgs_all jtu
413: , jtf_terr_all jt1
414: , jtf_qual_type_usgs jqtu
415: WHERE jtqu.terr_id = jt1.terr_id

Line 1975: FROM jtf_terr_qtype_usgs_all jtqu

1971:
1972: /* Check for territories for this Usage/Transaction Type */
1973: SELECT COUNT(*)
1974: INTO num_of_terr
1975: FROM jtf_terr_qtype_usgs_all jtqu
1976: , jtf_terr_usgs_all jtu
1977: , jtf_terr_all jt1
1978: , jtf_qual_type_usgs jqtu
1979: WHERE jtqu.terr_id = jt1.terr_id