APPS.AP_WEB_RECEIPT_MANAGEMENT_UTIL dependencies on AP_EXPENSE_REPORT_LINES_ALL

Line 168: from AP_EXPENSE_REPORT_LINES_ALL aerl,

164:
165: CURSOR line_cur IS
166: select aerl.receipt_required_flag,
167: aerl.receipt_missing_flag
168: from AP_EXPENSE_REPORT_LINES_ALL aerl,
169: AP_EXPENSE_REPORT_PARAMS_ALL erp
170: where aerl.report_header_id = p_report_header_id
171: and erp.parameter_id = aerl.web_parameter_id
172: and NVL(erp.expense_type_code,'NOT_DEFINED') not in ('PERSONAL','ROUNDING');

Line 262: from ap_expense_report_lines_all aerl

258: from AP_EXPENSE_REPORT_HEADERS_ALL aerh
259: where aerh.report_header_id = l_report_header_id
260: and holding_report_header_id is not null
261: and NOT EXISTS (select 1
262: from ap_expense_report_lines_all aerl
263: where aerl.report_header_id = aerh.report_header_id
264: and aerl.credit_card_trx_id IS NULL);
265:
266: header_rec header_cur%ROWTYPE;