DBA Data[Home] [Help]

APPS.JTF_QUAL_TYPES_PKG dependencies on DUAL

Line 28: CURSOR C2 IS SELECT JTF_QUAL_TYPES_s.nextval FROM sys.dual;

24: x_ORG_ID IN NUMBER
25: ) IS
26: CURSOR C IS SELECT rowid FROM JTF_QUAL_TYPES_ALL
27: WHERE QUAL_TYPE_ID = x_QUAL_TYPE_ID;
28: CURSOR C2 IS SELECT JTF_QUAL_TYPES_s.nextval FROM sys.dual;
29: BEGIN
30: If (x_QUAL_TYPE_ID IS NULL) then
31: OPEN C2;
32: FETCH C2 INTO x_QUAL_TYPE_ID;