APPS.OZF_REASON_CODES_ALL_PKG dependencies on DUAL

Line 60: CURSOR C2 IS SELECT OZF_REASON_CODES_ALL_B_S.nextval FROM sys.dual;

56: l_reason_count NUMBER;
57:
58: CURSOR C IS SELECT rowid FROM OZF_REASON_CODES_ALL_B
59: WHERE REASON_CODE_ID = px_REASON_CODE_ID;
60: CURSOR C2 IS SELECT OZF_REASON_CODES_ALL_B_S.nextval FROM sys.dual;
61: CURSOR C_REASON_COUNT(l_reason_code_id NUMBER) IS
62: SELECT COUNT(REASON_CODE_ID)
63: FROM OZF_REASON_CODES_ALL_B
64: WHERE REASON_CODE_ID = l_reason_code_id;

Line 70: from dual;

66: BEGIN
67: /* IF (px_ORG_ID IS NULL OR px_ORG_ID = FND_API.G_MISS_NUM) THEN
68: select nvl(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99)
69: into px_ORG_ID
70: from dual;
71: END IF; */
72:
73: IF (px_REASON_CODE_ID IS NULL) THEN
74: LOOP