DBA Data[Home] [Help]

APPS.AP_WEB_EXPORT_ER dependencies on AP_EXPENSE_REPORT_PARAMS_ALL

Line 837: select parameter_id into l_parameter_id from ap_expense_report_params_all where expense_type_code = 'PERSONAL';

833: l_debug_info := 'Fetching Header Total';
834: select total into l_header_total from ap_expense_report_headers_all where report_header_id = p_report_header_id;
835:
836: -- Bug 14627375: Personal expenses to be excluded
837: select parameter_id into l_parameter_id from ap_expense_report_params_all where expense_type_code = 'PERSONAL';
838:
839: l_debug_info := 'Fetching Line Total';
840: select nvl(sum(amount),0) into l_line_total
841: from ap_expense_report_lines_all