19: else
20: begin
21: select null
22: into dummy
23: from sys.dual
24: where exists (
25: select null
26: from pa_draft_revenues
27: where project_id = X_project_id
41: draft_revenue_num = X_draft_revenue_num;
42: begin
43: select null
44: into dummy
45: from sys.dual
46: where not exists (
47: select null
48: from pa_draft_revenues
49: where project_id = X_project_id
74: else
75: begin
76: select null
77: into dummy
78: from sys.dual
79: where exists (
80: select null
81: from pa_draft_revenues
82: where project_id = X_project_id
98:
99: begin
100: select null
101: into dummy
102: from sys.dual
103: where not exists (
104: select null
105: from pa_draft_revenues
106: where project_id = X_project_id
117:
118: begin
119: select null
120: into dummy
121: from sys.dual
122: where not exists (
123: select null
124: from pa_draft_invoices
125: where (project_id, draft_invoice_num) in
161:
162: begin
163: select null
164: into dummy
165: from sys.dual
166: where not exists (
167: select null
168: from pa_draft_revenues
169: where project_id = X_project_id