10: return number
11: is
12: cursor c1 is
13: SELECT 1
14: FROM sys.dual
15: WHERE exists (SELECT NULL
16: FROM pa_draft_invoices a, pa_agreements b
17: WHERE a.project_id = x_project_id
18: AND a.agreement_id = b.agreement_id