DBA Data[Home] [Help]

APPS.AS_LEAD_COMPETITORS_PKG dependencies on DUAL

Line 52: CURSOR C2 IS SELECT AS_LEAD_COMPETITORS_S.nextval FROM sys.dual;

48: p_RELATIONSHIP_PARTY_ID NUMBER,
49: p_COMPETITOR_ID NUMBER)
50:
51: IS
52: CURSOR C2 IS SELECT AS_LEAD_COMPETITORS_S.nextval FROM sys.dual;
53: BEGIN
54: If (px_LEAD_COMPETITOR_ID IS NULL) OR (px_LEAD_COMPETITOR_ID = FND_API.G_MISS_NUM) then
55: OPEN C2;
56: FETCH C2 INTO px_LEAD_COMPETITOR_ID;