DBA Data[Home] [Help]

APPS.AS_LEAD_COMP_PRODUCTS_PKG dependencies on DUAL

Line 47: CURSOR C2 IS SELECT AS_LEAD_COMP_PRODUCTS_S.nextval FROM sys.dual;

43: p_CREATED_BY NUMBER,
44: p_CREATION_DATE DATE)
45:
46: IS
47: CURSOR C2 IS SELECT AS_LEAD_COMP_PRODUCTS_S.nextval FROM sys.dual;
48: BEGIN
49: If (px_LEAD_COMPETITOR_PROD_ID IS NULL) OR (px_LEAD_COMPETITOR_PROD_ID = FND_API.G_MISS_NUM) then
50: OPEN C2;
51: FETCH C2 INTO px_LEAD_COMPETITOR_PROD_ID;