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
2052: AND e.vendor_id IS NOT NULL
2053: AND je.reference_1 = p_ref1