APPS.JL_ZZ_AR_LIBRARY_1_PKG dependencies on DUAL

Line 225: FROM dual

221: BEGIN
222: Errcd := 0;
223: SELECT DECODE (amt_due_remain_char, '0', 'CL', 'OP')
224: INTO status
225: FROM dual
226: WHERE rownum = row_number;
227: EXCEPTION
228: WHEN OTHERS THEN
229: Errcd := SQLCODE;

Line 243: FROM dual

239: BEGIN
240: Errcd := 0;
241: SELECT DECODE (amt_due_remain_char, '0', gl_date, NULL)
242: INTO gl_date_closed
243: FROM dual
244: WHERE rownum = row_number;
245: EXCEPTION
246: WHEN OTHERS THEN
247: Errcd := SQLCODE;

Line 261: FROM dual

257: BEGIN
258: Errcd := 0;
259: SELECT DECODE (amt_due_remain_char, '0', gl_date, NULL)
260: INTO actual_date_closed
261: FROM dual
262: WHERE rownum = row_number;
263: EXCEPTION
264: WHEN OTHERS THEN
265: Errcd := SQLCODE;

Line 434: 'from dual ',

430: l_trx_num_cursor := dbms_sql.open_cursor;
431: dbms_sql.parse(l_trx_num_cursor,
432: 'select '||
433: seq_name||'.nextval seq_number '||
434: 'from dual ',
435: dbms_sql.NATIVE);
436:
437: dbms_sql.define_column(l_trx_num_cursor, 1, seq_no);
438: