APPS.HZ_MERGE_DICTIONARY_PKG dependencies on DUAL

Line 244: CURSOR C2 IS SELECT HZ_MERGE_DICTIONARY_S.nextval FROM sys.dual;

240: IS
241: CURSOR C1(cp_md_id NUMBER) IS
242: SELECT MERGE_DICT_ID FROM HZ_MERGE_DICTIONARY WHERE MERGE_DICT_ID=cp_md_id;
243:
244: CURSOR C2 IS SELECT HZ_MERGE_DICTIONARY_S.nextval FROM sys.dual;
245:
246: CURSOR C3 IS SELECT 10*(1+trunc(nvl(max(SEQUENCE_NO), 0)/10))
247: FROM HZ_MERGE_DICTIONARY
248: WHERE PARENT_ENTITY_NAME = p_PARENT_ENTITY_NAME;