[Home] [Help]
207: CURSOR line_cur IS
208: select aerl.receipt_required_flag,
209: aerl.receipt_missing_flag
210: from AP_EXPENSE_REPORT_LINES_ALL aerl,
211: AP_EXPENSE_REPORT_PARAMS_ALL erp
212: where aerl.report_header_id = p_report_header_id
213: and erp.parameter_id = aerl.web_parameter_id
214: and NVL(erp.expense_type_code,'NOT_DEFINED') not in ('PERSONAL','ROUNDING');
215: