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;