--Expense Reports on Oracle iProcurement
select * from ap_expense_report_lines_all
where amount is null
and report_header_id in (
select report_header_id
from ap_expense_report_headers_all
where invoice_num = :p_expense_report_num);
select * from ap_exp_report_dists_all
where amount is null
and report_header_id in (
select report_header_id
from ap_expense_report_headers_all
where invoice_num = :p_expense_report_num);