DBA Data[Home] [Help]

APPS.JTF_TERR_TYPES_PKG dependencies on DUAL

Line 42: CURSOR C2 IS SELECT JTF_TERR_TYPES_s.nextval FROM sys.dual;

38: x_ORG_ID IN NUMBER
39: ) IS
40: CURSOR C IS SELECT rowid FROM JTF_TERR_TYPES
41: WHERE TERR_TYPE_ID = x_TERR_TYPE_ID;
42: CURSOR C2 IS SELECT JTF_TERR_TYPES_s.nextval FROM sys.dual;
43: BEGIN
44: If (x_TERR_TYPE_ID IS NULL) then
45: OPEN C2;
46: FETCH C2 INTO x_TERR_TYPE_ID;