DBA Data[Home] [Help]

APPS.JTF_TERR_TYPE_QUAL_PKG dependencies on DUAL

Line 37: CURSOR C2 IS SELECT JTF_TERR_TYPE_QUAL_s.nextval FROM sys.dual;

33: x_ORG_ID IN NUMBER
34: ) IS
35: CURSOR C IS SELECT rowid FROM JTF_TERR_TYPE_QUAL
36: WHERE TERR_TYPE_QUAL_ID = x_TERR_TYPE_QUAL_ID;
37: CURSOR C2 IS SELECT JTF_TERR_TYPE_QUAL_s.nextval FROM sys.dual;
38: BEGIN
39: If (x_TERR_TYPE_QUAL_ID IS NULL) then
40: OPEN C2;
41: FETCH C2 INTO x_TERR_TYPE_QUAL_ID;