2043: CURSOR projects_vendor_cur (p_ref1 IN VARCHAR2) IS
2044: SELECT e.vendor_id ven_id
2045: FROM gl_je_lines je ,
2046: gl_je_headers jh ,
2047: pa_cost_distribution_lines_all cdl,
2048: pa_expenditure_items_all ei ,
2049: pa_expenditures_all e
2050: WHERE je.je_header_id = jh.je_header_id
2051: AND je.reference_1 IS NOT NULL