APPS.GML_GASNO dependencies on DUAL

Line 92: FROM sys.dual;

88: xProgress := 'GASNO-10-1005';
89: BEGIN
90: SELECT ece_output_runs_s.NEXTVAL
91: INTO p_RunID
92: FROM sys.dual;
93: EXCEPTION
94: WHEN NO_DATA_FOUND THEN
95: ec_debug.pl ( 0,
96: 'EC',

Line 547: dual

543: lpad(p_BOL_No_From, v_format_size, v_pad_char)
544: INTO
545: v_BOL_No_From
546: FROM
547: dual
548: ;
549: End If;
550: If ( p_BOL_No_To is NOT NULL ) Then
551: v_BOL_No_To := lpad(p_BOL_No_To, v_format_size, v_pad_char);

Line 558: dual

554: lpad(p_BOL_No_To, v_format_size, v_pad_char)
555: INTO
556: v_BOL_No_To
557: FROM
558: dual
559: ;
560: End If;
561: End If;
562:

Line 1249: FROM sys.dual;

1245: xProgress := 'GASNOB-10-1810';
1246: BEGIN
1247: SELECT GML_GASNO_SHIPMENTS_S.nextval
1248: INTO v_SHP_Key
1249: FROM sys.dual;
1250: EXCEPTION
1251: WHEN NO_DATA_FOUND THEN
1252: ec_debug.pl ( 0,
1253: 'EC',

Line 1418: FROM sys.dual;

1414: xProgress := 'GASNOB-10-1950';
1415: BEGIN
1416: SELECT GML_GASNO_ORDERS_S.nextval
1417: INTO v_ORD_Key
1418: FROM sys.dual;
1419: EXCEPTION
1420: WHEN NO_DATA_FOUND THEN
1421: ec_debug.pl ( 0,
1422: 'EC',

Line 1650: FROM sys.dual;

1646: xProgress := 'GASNOB-10-2190';
1647: BEGIN
1648: SELECT GML_GASNO_DETAILS_S.nextval
1649: INTO v_DTL_Key
1650: FROM sys.dual;
1651: EXCEPTION
1652: WHEN NO_DATA_FOUND THEN
1653: ec_debug.pl ( 0,
1654: 'EC',