DBA Data[Home] [Help]

APPS.JTF_QUAL_TYPE_USGS_PKG dependencies on DUAL

Line 22: CURSOR C2 IS SELECT JTF_QUAL_TYPE_USGS_s.nextval FROM sys.dual;

18: x_ORG_ID IN NUMBER
19: ) IS
20: CURSOR C IS SELECT rowid FROM JTF_QUAL_TYPE_USGS
21: WHERE QUAL_TYPE_USG_ID = x_QUAL_TYPE_USG_ID;
22: CURSOR C2 IS SELECT JTF_QUAL_TYPE_USGS_s.nextval FROM sys.dual;
23: BEGIN
24: If (x_QUAL_TYPE_USG_ID IS NULL) then
25: OPEN C2;
26: FETCH C2 INTO x_QUAL_TYPE_USG_ID;