DBA Data[Home] [Help]

APPS.JTF_TERR_RSC_PKG dependencies on DUAL

Line 34: CURSOR C2 IS SELECT JTF_TERR_RSC_s.nextval FROM sys.dual;

30: x_ORG_ID IN NUMBER
31: ) IS
32: CURSOR C IS SELECT rowid FROM JTF_TERR_RSC_ALL
33: WHERE TERR_RSC_ID = x_TERR_RSC_ID;
34: CURSOR C2 IS SELECT JTF_TERR_RSC_s.nextval FROM sys.dual;
35: BEGIN
36: If (x_TERR_RSC_ID IS NULL) then
37: OPEN C2;
38: FETCH C2 INTO x_TERR_RSC_ID;

Line 122: CURSOR C2 IS SELECT JTF_TERR_RSC_s.nextval FROM sys.dual;

118: x_ATTRIBUTE15 IN VARCHAR2
119: ) IS
120: CURSOR C IS SELECT rowid FROM JTF_TERR_RSC_ALL
121: WHERE TERR_RSC_ID = x_TERR_RSC_ID;
122: CURSOR C2 IS SELECT JTF_TERR_RSC_s.nextval FROM sys.dual;
123: BEGIN
124: If (x_TERR_RSC_ID IS NULL) then
125: OPEN C2;
126: FETCH C2 INTO x_TERR_RSC_ID;