DBA Data[Home] [Help]

APPS.JTF_TERR_CNR_GROUP_VALUES_PKG dependencies on DUAL

Line 26: CURSOR C2 IS SELECT JTF_TERR_CNR_GROUP_VALUES_s.nextval FROM sys.dual;

22: x_ORG_ID IN NUMBER
23: ) IS
24: CURSOR C IS SELECT rowid FROM JTF_TERR_CNR_GROUP_VALUES
25: WHERE CNR_GROUP_VALUE_ID = x_CNR_GROUP_VALUE_ID;
26: CURSOR C2 IS SELECT JTF_TERR_CNR_GROUP_VALUES_s.nextval FROM sys.dual;
27: BEGIN
28: If (x_CNR_GROUP_VALUE_ID IS NULL) then
29: OPEN C2;
30: FETCH C2 INTO x_CNR_GROUP_VALUE_ID;