DBA Data[Home] [Help]

APPS.CSD_RO_DIAGNOSTIC_CODES_PKG dependencies on DUAL

Line 44: CURSOR C2 IS SELECT CSD_RO_DIAGNOSTIC_CODES_S1.nextval FROM sys.dual;

40: ,p_DIAGNOSTIC_ITEM_ID NUMBER -- rfieldma, 4666403
41: )
42:
43: IS
44: CURSOR C2 IS SELECT CSD_RO_DIAGNOSTIC_CODES_S1.nextval FROM sys.dual;
45: BEGIN
46: If (px_RO_DIAGNOSTIC_CODE_ID IS NULL) OR (px_RO_DIAGNOSTIC_CODE_ID = FND_API.G_MISS_NUM) then
47: OPEN C2;
48: FETCH C2 INTO px_RO_DIAGNOSTIC_CODE_ID;