DBA Data[Home] [Help]

APPS.JTF_TERR_QUAL_PKG dependencies on DUAL

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

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