171: dummy1 varchar2(1);
172:
173: cursor expenditure( p_job_id varchar ) is
174: SELECT 'Y'
175: FROM DUAL
176: WHERE EXISTS (
177: select null
178: from pa_expenditure_items_all pa
179: where (pa.job_id is not null