DBA Data[Home] [Help]

APPS.PO_REQAPPROVAL_ACTION dependencies on DUAL

Line 281: from sys.dual;

277:
278: begin
279: select (trunc(nvl(x_acceptance_due_date, sysdate)) - trunc(sysdate)) * 60
280: into x_minutes_to_acceptance
281: from sys.dual;
282:
283: if x_minutes_to_acceptance is not null then
284:
285: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,

Line 1871: FROM dual

1867: -- SQL Why :If no errors and only warnings then, success is returned
1868: -- SQL JOIN: NONE
1869: SELECT 'E'
1870: INTO l_error
1871: FROM dual
1872: WHERE EXISTS (SELECT 1
1873: FROM PO_ONLINE_REPORT_TEXT
1874: WHERE online_report_id = x_online_report_id
1875: AND NVL(message_type, 'E') = 'E'); -- Bug 3906870