342: AND ct.complete_flag = 'Y'
343: UNION ALL
344: SELECT count(*)
345: FROM 346: gl_je_lines jel, 347: gl_je_headers jeh
348: WHERE jel.last_update_date between p_from_date and p_to_date
349: AND jel.status = 'P'
350: AND jel.je_header_id = jeh.je_header_id