Line 54: CURSOR C2 IS SELECT JTF_QUAL_USGS_s.nextval FROM sys.dual;
50: x_use_in_lookup_flag IN VARCHAR2
51: ) IS
52: CURSOR C IS SELECT rowid FROM JTF_QUAL_USGS
53: WHERE QUAL_USG_ID = x_QUAL_USG_ID; 54: CURSOR C2 IS SELECT JTF_QUAL_USGS_s.nextval FROM sys.dual; 55: BEGIN
56: If (x_QUAL_USG_ID IS NULL) then
57: OPEN C2;
58: FETCH C2 INTO x_QUAL_USG_ID;