DBA Data[Home] [Help]

APPS.JTF_TYPE_QTYPE_USGS_PKG dependencies on DUAL

Line 23: CURSOR C2 IS SELECT JTF_TYPE_QTYPE_USGS_s.nextval FROM sys.dual;

19: x_ORG_ID IN NUMBER
20: ) IS
21: CURSOR C IS SELECT rowid FROM JTF_TYPE_QTYPE_USGS
22: WHERE TYPE_QTYPE_USG_ID = x_TYPE_QTYPE_USG_ID;
23: CURSOR C2 IS SELECT JTF_TYPE_QTYPE_USGS_s.nextval FROM sys.dual;
24: BEGIN
25: If (x_TYPE_QTYPE_USG_ID IS NULL) then
26: OPEN C2;
27: FETCH C2 INTO x_TYPE_QTYPE_USG_ID;