APPS.CN_DIMENSIONS_PKG dependencies on DUAL

Line 175: into l_env_org_id from dual;

171: l_table_id number;
172: begin
173: -- get environment org ID
174: select X_ORG_ID
175: into l_env_org_id from dual;
176:
177: -- clean up cn_objects and remove pointers to non-existent dimension ID
178: select source_table_id into l_table_id
179: from cn_dimensions where dimension_id = X_DIMENSION_ID

Line 462: SELECT cn_dimensions_s.nextval INTO Ret_Val FROM dual;

458: FUNCTION New_Dimension RETURN NUMBER IS
459: Ret_Val NUMBER(15);
460: BEGIN
461:
462: SELECT cn_dimensions_s.nextval INTO Ret_Val FROM dual;
463:
464: RETURN Ret_Val;
465:
466: END New_Dimension;