DBA Data[Home] [Help]

APPS.CSP_NOTIFICATIONS_PKG dependencies on DUAL

Line 54: CURSOR C2 IS SELECT CSP_NOTIFICATIONS_S1.nextval FROM sys.dual;

50: p_SUPPRESS_END_DATE DATE ,
51: p_NOTIFICATION_TYPE VARCHAR2 )
52:
53: IS
54: CURSOR C2 IS SELECT CSP_NOTIFICATIONS_S1.nextval FROM sys.dual;
55: BEGIN
56: If (px_NOTIFICATION_ID IS NULL) OR (px_NOTIFICATION_ID = FND_API.G_MISS_NUM) then
57: OPEN C2;
58: FETCH C2 INTO px_NOTIFICATION_ID;