APPS.PO_GML_CONV_MIG dependencies on DUAL

Line 218: FROM sys.dual

214:
215: /* Cursor used to check if the hazard class is already in the table */
216: CURSOR c_check_existence (v_hazard_class VARCHAR2) IS
217: SELECT 1
218: FROM sys.dual
219: WHERE EXISTS (SELECT 1
220: FROM po_hazard_classes_tl
221: WHERE hazard_class = v_hazard_class);
222:

Line 226: FROM sys.dual;

222:
223: /* Cursor used to retrieve the next sequence number */
224: CURSOR c_get_seq IS
225: SELECT PO_HAZARD_CLASSES_S.nextval
226: FROM sys.dual;
227:
228: /* Cursor used to retrieve translated descriptions for installed languages */
229: CURSOR c_get_translated (v_hazard_class VARCHAR2) IS
230: SELECT *

Line 511: FROM sys.dual

507:
508: /* Cursor used to check if the un number is already in the table */
509: CURSOR c_check_existence (v_un_number VARCHAR2) IS
510: SELECT 1
511: FROM sys.dual
512: WHERE EXISTS (SELECT 1
513: FROM po_un_numbers_tl
514: WHERE un_number = 'UN'||v_un_number);
515:

Line 519: FROM sys.dual;

515:
516: /* Cursor used to retrieve the next sequence number */
517: CURSOR c_get_seq IS
518: SELECT PO_UN_NUMBERS_S.nextval
519: FROM sys.dual;
520:
521: BEGIN
522:
523: x_failure_count := 0;