DBA Data[Home] [Help]

APPS.JTF_SEEDED_QUAL_PKG dependencies on DUAL

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

24: x_ORG_ID IN NUMBER
25: ) IS
26: CURSOR C IS SELECT rowid FROM JTF_SEEDED_QUAL_ALL_B
27: WHERE SEEDED_QUAL_ID = x_SEEDED_QUAL_ID and NVL(ORG_ID, -99) = NVL(x_ORG_ID, -99);
28: CURSOR C2 IS SELECT JTF_SEEDED_QUAL_s.nextval FROM sys.dual;
29: BEGIN
30: If (x_SEEDED_QUAL_ID IS NULL) then
31: OPEN C2;
32: FETCH C2 INTO x_SEEDED_QUAL_ID;