APPS.JTF_TERR_DENORM_PVT dependencies on JTF_TERR_USGS

Line 32: , JTF_TERR_USGS TRUSG

28: CURSOR LC_TERR IS
29: SELECT TR1.TERR_ID TERR_ID
30: , TR1.PARENT_TERRITORY_ID PARENT_TERR_ID
31: FROM JTF_TERR TR1
32: , JTF_TERR_USGS TRUSG
33: WHERE TR1.TERR_ID = TRUSG.TERR_ID
34: AND TRUSG.SOURCE_ID = P_SOURCE_ID ;
35:
36: l_status varchar2(10);