APPS.AP_IAW_PKG dependencies on DUAL

Line 2287: FROM dual;

2283: fnd_client_info.set_org_context(p_inv_aprvl_hist.org_id);
2284:
2285: SELECT AP_INV_APRVL_HIST_S.nextval
2286: INTO l_hist_id
2287: FROM dual;
2288:
2289: SELECT max(notification_order) + 1
2290: INTO l_not_cnt
2291: FROM ap_inv_aprvl_hist_all

Line 2389: FROM dual;

2385:
2386:
2387: SELECT AP_INV_APRVL_HIST_S.nextval
2388: INTO l_hist_id
2389: FROM dual;
2390:
2391: SELECT max(nvl(notification_order,0)) + 1
2392: INTO l_not_cnt
2393: FROM ap_inv_aprvl_hist_all

Line 2458: FROM dual;

2454: fnd_client_info.set_org_context(p_line_aprvl_hist.org_id);
2455:
2456: SELECT AP_INV_APRVL_HIST_S.nextval
2457: INTO l_hist_id
2458: FROM dual;
2459:
2460: SELECT max(notification_order) + 1
2461: INTO l_not_cnt
2462: FROM ap_line_aprvl_hist

Line 2586: FROM dual;

2582: EXIT WHEN Lines_Cur%NOTFOUND OR Lines_Cur%NOTFOUND IS NULL;
2583:
2584: SELECT AP_INV_APRVL_HIST_S.nextval
2585: INTO l_hist_id
2586: FROM dual;
2587:
2588: SELECT max(nvl(notification_order,0)) + 1
2589: INTO l_not_cnt
2590: FROM ap_line_aprvl_hist

Line 4448: from dual

4444: 'ORG_ID');
4445: begin
4446: select 'X'
4447: into l_f
4448: from dual
4449: where exists( select 'e' from ap_invoices_all
4450: where invoice_id = l_invoice_id and
4451: org_id = l_org_id and wfapproval_status = 'REJECTED'
4452: union all