APPS.CSD_MRO_SERIAL_NUMBERS_PKG dependencies on DUAL
Line 40: CURSOR C2 IS SELECT CSD_MRO_SERIAL_NUMBERS_S1.nextval FROM sys.dual;
36: ,p_CUSTOMER_PRODUCT_ID NUMBER
37: ,p_REFERENCE_NUMBER VARCHAR2)
38:
39: IS 40: CURSOR C2 IS SELECT CSD_MRO_SERIAL_NUMBERS_S1.nextval FROM sys.dual; 41: BEGIN
42: If (px_MRO_SERIAL_NUMBER_ID IS NULL) OR (px_MRO_SERIAL_NUMBER_ID = FND_API.G_MISS_NUM) then
43: OPEN C2;
44: FETCH C2 INTO px_MRO_SERIAL_NUMBER_ID;