DBA Data[Home] [Help]

APPS.JTY_TERR_DENORM_RULES_PVT dependencies on JTF_TERR_USGS_ALL

Line 1081: FROM JTF_TERR_QUAL_ALL jtqa, JTF_TERR_USGS_ALL jtua, JTF_TERR_ALL jta

1077:
1078:
1079: CURSOR c_actual_tab_reference is
1080: SELECT COUNT(*)
1081: FROM JTF_TERR_QUAL_ALL jtqa, JTF_TERR_USGS_ALL jtua, JTF_TERR_ALL jta
1082: WHERE jtqa.QUAL_USG_ID NOT IN
1083: (-1040, -1041, -1042, -1044, -1744, -1734, -1048, -1096, -1038, -1061, -1060, -1043,
1084: -1095, -1051, -1050, -1037, -1210, -1045, -1046, -1206, -1213, -1039, -1218)
1085: AND JTQA.TERR_ID = JTUA.TERR_ID