DBA Data[Home] [Help]

APPS.CSD_AHL_W_CONTRACT_XREF_PKG dependencies on DUAL

Line 46: CURSOR C2 IS SELECT CSD_AHL_W_CONTRACT_XREF_S1.nextval FROM sys.dual;

42: ,p_REPAIR_LINE_ID NUMBER
43: ,p_INSTANCE_ID NUMBER) --yvchen
44:
45: IS
46: CURSOR C2 IS SELECT CSD_AHL_W_CONTRACT_XREF_S1.nextval FROM sys.dual;
47: BEGIN
48: If (px_WARRANTY_CONTRACT_XREF_ID IS NULL) OR (px_WARRANTY_CONTRACT_XREF_ID = FND_API.G_MISS_NUM) then
49: OPEN C2;
50: FETCH C2 INTO px_WARRANTY_CONTRACT_XREF_ID;