[Home] [Help]
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);