DBA Data[Home] [Help]

APPS.JTF_QUAL_USGS_PKG dependencies on DUAL

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;