APPS.PO_GML_CONV_MIG dependencies on DUAL

Line 192: FROM sys.dual

188:
189: /* Cursor used to check if the hazard class is already in the table */
190: CURSOR c_check_existence (v_hazard_class VARCHAR2) IS
191: SELECT 1
192: FROM sys.dual
193: WHERE EXISTS (SELECT 1
194: FROM po_hazard_classes_tl
195: WHERE hazard_class = v_hazard_class);
196:

Line 200: FROM sys.dual;

196:
197: /* Cursor used to retrieve the next sequence number */
198: CURSOR c_get_seq IS
199: SELECT PO_HAZARD_CLASSES_S.nextval
200: FROM sys.dual;
201:
202: /* Cursor used to retrieve translated descriptions for installed languages */
203: CURSOR c_get_translated (v_hazard_class VARCHAR2) IS
204: SELECT *

Line 485: FROM sys.dual

481:
482: /* Cursor used to check if the un number is already in the table */
483: CURSOR c_check_existence (v_un_number VARCHAR2) IS
484: SELECT 1
485: FROM sys.dual
486: WHERE EXISTS (SELECT 1
487: FROM po_un_numbers_tl
488: WHERE un_number = 'UN'||v_un_number);
489:

Line 493: FROM sys.dual;

489:
490: /* Cursor used to retrieve the next sequence number */
491: CURSOR c_get_seq IS
492: SELECT PO_UN_NUMBERS_S.nextval
493: FROM sys.dual;
494:
495: BEGIN
496:
497: x_failure_count := 0;