APPS.ENI_UPGRADE_VSET dependencies on DUAL

Line 301: SELECT 1 exist_flag FROM DUAL

297: -- AND ROWNUM = 1)
298: -- AND p_validation_mode = 'N';
299:
300: CURSOR c_check_temp(segment VARCHAR2) IS
301: SELECT 1 exist_flag FROM DUAL
302: WHERE NOT EXISTS(SELECT child_code
303: FROM eni_vset_hrchy_temp
304: WHERE child_code = segment
305: AND hrchy_flag = 'Y'

Line 385: SELECT p_top_node, NULL, 'N' FROM DUAL;

381: FROM FND_FLEX_VALUE_CHILDREN_V
382: WHERE FLEX_VALUE_SET_ID = g_value_set_id
383: AND FLEX_VALUE <> p_top_node
384: UNION ALL
385: SELECT p_top_node, NULL, 'N' FROM DUAL;
386:
387: -- populating the hierarchy from only the top node down
388: -- into the temp table
389: