APPS.AP_WEB_RECEIPT_MANAGEMENT_UTIL dependencies on AP_EXPENSE_REPORT_LINES_ALL

Line 210: from AP_EXPENSE_REPORT_LINES_ALL aerl,

206:
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');

Line 312: from ap_expense_report_lines_all aerl

308: from AP_EXPENSE_REPORT_HEADERS_ALL aerh
309: where aerh.report_header_id = l_report_header_id
310: and holding_report_header_id is not null
311: and NOT EXISTS (select 1
312: from ap_expense_report_lines_all aerl
313: where aerl.report_header_id = aerh.report_header_id
314: and aerl.credit_card_trx_id IS NULL);
315:
316: header_rec header_cur%ROWTYPE;