[Home] [Help]
678: cursor c1 is
679: SELECT 1
680: FROM sys.dual
681: WHERE EXISTS (SELECT NULL
682: FROM pa_draft_invoices
683: WHERE project_id = x_project_id);
684:
685: c1_rec c1%rowtype;
686:
1601: into dummy
1602: from sys.dual
1603: where not exists (
1604: select null
1605: from pa_draft_invoices_all
1606: where project_id = x_project_id);
1607: exception
1608: when no_data_found then
1609: x_err_code := 40;