APPS.JTF_TERR_USGS_PKG dependencies on JTF_TERR_USGS_S
Line 23: CURSOR C2 IS SELECT JTF_TERR_USGS_s.nextval FROM sys.dual;
19: x_ORG_ID IN NUMBER
20: ) IS
21: CURSOR C IS SELECT rowid FROM JTF_TERR_USGS_all
22: WHERE TERR_USG_ID = x_TERR_USG_ID; 23: CURSOR C2 IS SELECT JTF_TERR_USGS_s.nextval FROM sys.dual; 24: BEGIN
25: If (x_TERR_USG_ID IS NULL) then
26: OPEN C2;
27: FETCH C2 INTO x_TERR_USG_ID;