APPS.CSP_NOTIFICATION_DETAILS_PKG dependencies on DUAL
Line 47: CURSOR C2 IS SELECT CSP_NOTIFICATION_DETAILS_S1.nextval FROM sys.dual;
43: ,p_REPAIR_SUPPLIER_ID NUMBER
44: ,p_ORDER_NUMBER NUMBER
45: )
46: IS 47: CURSOR C2 IS SELECT CSP_NOTIFICATION_DETAILS_S1.nextval FROM sys.dual; 48: BEGIN
49: If (px_NOTIFICATION_DETAIL_ID IS NULL) OR (px_NOTIFICATION_DETAIL_ID = FND_API.G_MISS_NUM) then
50: OPEN C2;
51: FETCH C2 INTO px_NOTIFICATION_DETAIL_ID;