DBA Data[Home] [Help]

APPS.AP_WEB_DB_EXPLINE_PKG dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

Line 643: from ap_expense_report_headers_all aerh1

639: FROM ap_expense_report_lines aerl
640: WHERE aerl.report_header_id in (select p_report_header_id from dual
641: union
642: select aerh1.report_header_id
643: from ap_expense_report_headers_all aerh1
644: where aerh1.SHORTPAY_PARENT_ID = p_report_header_id)
645: AND (itemization_parent_id is null OR itemization_parent_id = -1)
646: AND aerl.web_parameter_id <> l_roundingParameterId
647: AND aerl.amount <> NVL(aerl.submitted_amount,aerl.amount)

Line 5069: UPDATE ap_expense_report_headers_all

5065:
5066: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'start resetApplyAdvances');
5067:
5068: -- bug : 4001778/3654956
5069: UPDATE ap_expense_report_headers_all
5070: SET maximum_amount_to_apply = null,
5071: advance_invoice_to_apply = null,
5072: apply_advances_default = null,
5073: prepay_apply_flag = null,