APPS.AP_IMPORT_INVOICES_PKG dependencies on DUAL

Line 2612: FROM dual;

2608: SELECT DECODE(tab_lines_table(j).line_type_lookup_code, 'ITEM',
2609: DECODE(tab_lines_table(j).match_type, NULL, 'NOT_MATCHED',tab_lines_table(j).match_type),
2610: DECODE(tab_lines_table(j).rcv_transaction_id, NULL, 'NOT_MATCHED','OTHER_TO_RECEIPT'))
2611: INTO lines_tab(k).match_type
2612: FROM dual;
2613: EXCEPTION
2614: WHEN OTHERS THEN
2615: NULL;
2616: END;

Line 4212: FROM dual;

4208: --bug 7636400
4209: /*
4210: SELECT to_char(ap_invoice_import_wfevent_s.nextval)
4211: INTO l_event_key
4212: FROM dual;
4213: */
4214:
4215: SELECT to_char(AP_INV_IMPORT_EVENT_S.nextval)
4216: INTO l_event_key

Line 4217: FROM dual;

4213: */
4214:
4215: SELECT to_char(AP_INV_IMPORT_EVENT_S.nextval)
4216: INTO l_event_key
4217: FROM dual;
4218:
4219: wf_event.raise( p_event_name => l_event_name,
4220: p_event_key => l_event_key,
4221: p_parameters => l_parameter_list);