[Home] [Help]
2813: NVL(aerl.PER_DIEM_RATE3,0) PER_DIEM_RATE3,
2814: NVL(end_expense_date - start_expense_date,0)+1 number_of_days,
2815: ph.day_period_code
2816: from ap_expense_report_lines_all aerl,
2817: ap_pol_headers ph,
2818: ap_expense_report_params_all erp
2819: where aerl.report_header_id = p_report_header_id
2820: and aerl.distribution_line_number = p_distribution_line_number
2821: and aerl.category_code = AP_WEB_POLICY_UTILS.c_PER_DIEM