DBA Data[Home] [Help]

APPS.JTF_TERR_RSC_ACCESS_PKG dependencies on DUAL

Line 25: CURSOR C2 IS SELECT JTF_TERR_RSC_ACCESS_s.nextval FROM sys.dual;

21: x_ORG_ID IN NUMBER
22: ) IS
23: CURSOR C IS SELECT rowid FROM JTF_TERR_RSC_ACCESS_ALL
24: WHERE TERR_RSC_ACCESS_ID = x_TERR_RSC_ACCESS_ID;
25: CURSOR C2 IS SELECT JTF_TERR_RSC_ACCESS_s.nextval FROM sys.dual;
26: BEGIN
27: If (x_TERR_RSC_ACCESS_ID IS NULL) then
28: OPEN C2;
29: FETCH C2 INTO x_TERR_RSC_ACCESS_ID;