APPS.CCT_MIDDLEWARE_PARAM_PKG dependencies on DUAL

Line 103: from dual where not exists (SELECT 1 FROM CCT_MIDDLEWARE_PARAMS WHERE NAME=P_NAME and MIDDLEWARE_TYPE_ID = P_MIDDLEWARE_TYPE_ID);

99: INSERT INTO CCT_MIDDLEWARE_PARAMS
100: (MIDDLEWARE_PARAM_ID, MIDDLEWARE_TYPE_ID, NAME, TYPE, LENGTH,ORDERING_SEQUENCE,DOMAIN_LOOKUP_TYPE,
101: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)
102: select CCT_MIDDLEWARE_PARAMS_S.NEXTVAL+1000, P_MIDDLEWARE_TYPE_ID, P_NAME, P_TYPE, P_LENGTH,P_ORDERING_SEQUENCE,P_DOMAIN_LOOKUP_TYPE,sysdate, 1, sysdate, 1
103: from dual where not exists (SELECT 1 FROM CCT_MIDDLEWARE_PARAMS WHERE NAME=P_NAME and MIDDLEWARE_TYPE_ID = P_MIDDLEWARE_TYPE_ID);
104:
105: ELSIF (csr_chk_param_exists%FOUND) THEN
106: -- Update
107: Fetch csr_chk_param_exists into l_param_id;