APPS.AP_WEB_AUDIT_UTILS dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

Line 618: AP_EXPENSE_REPORT_HEADERS_ALL aerh,

614: eo.overall_tolerance,
615: eo.org_id
616: from AP_POL_EXRATE_OPTIONS_ALL eo,
617: AP_EXPENSE_REPORT_LINES_ALL aerl,
618: AP_EXPENSE_REPORT_HEADERS_ALL aerh,
619: AP_POL_VIOLATIONS_ALL pv
620: where aerl.report_header_id = pv.report_header_id
621: and aerl.distribution_line_number = pv.distribution_line_number
622: and aerl.credit_card_trx_id is null

Line 1344: from AP_EXPENSE_REPORT_HEADERS_ALL aerh

1340: PROCEDURE set_audit_list_member(p_report_header_id IN NUMBER, p_reason_code IN VARCHAR2) IS
1341:
1342: CURSOR report_cur IS
1343: select aerh.employee_id, aerh.org_id
1344: from AP_EXPENSE_REPORT_HEADERS_ALL aerh
1345: where aerh.report_header_id = p_report_header_id;
1346:
1347: CURSOR required_cur IS
1348: select count(1) required_count

Line 1740: ap_expense_report_headers_all aerh,

1736: CURSOR site_cur IS
1737: SELECT site.invoice_currency_code default_currency_code
1738: FROM ap_suppliers vdr,
1739: ap_supplier_sites_all site,
1740: ap_expense_report_headers_all aerh,
1741: financials_system_params_all fp
1742: WHERE aerh.report_header_id = p_report_header_id
1743: AND aerh.org_id = site.org_id
1744: AND aerh.org_id = fp.org_id

Line 1752: ap_expense_report_headers_all aerh,

1748:
1749: CURSOR vendor_cur IS
1750: SELECT nvl(vdr.invoice_currency_code,sp.base_currency_code) default_currency_code
1751: FROM ap_suppliers vdr,
1752: ap_expense_report_headers_all aerh,
1753: ap_system_parameters_all sp
1754: WHERE vdr.employee_id = aerh.employee_id
1755: AND aerh.report_header_id = p_report_header_id
1756: AND aerh.org_id = sp.org_id;

Line 1762: ap_expense_report_headers_all aerh,

1758: CURSOR advance_cur(p_default_currency_code IN VARCHAR2) IS
1759: SELECT get_available_prepays(vdr.vendor_id) advance_count,
1760: aerh.employee_id
1761: FROM ap_invoices_all i,
1762: ap_expense_report_headers_all aerh,
1763: ap_suppliers vdr
1764: WHERE i.vendor_id = vdr.vendor_id
1765: AND aerh.report_header_id = p_report_header_id
1766: AND vdr.employee_id = aerh.employee_id

Line 1775: FROM ap_expense_report_headers_all aerh

1771: AND ROWNUM = 1;
1772:
1773: CURSOR applied_cur(p_employee_id NUMBER, p_default_currency_code IN VARCHAR2) IS
1774: SELECT nvl(sum(maximum_amount_to_apply),0) applied_prepayment
1775: FROM ap_expense_report_headers_all aerh
1776: WHERE aerh.employee_id = p_employee_id
1777: AND aerh.vouchno = 0
1778: AND aerh.default_currency_code = p_default_currency_code
1779: GROUP BY aerh.employee_id;

Line 2623: ap_expense_report_headers_all aerh,

2619: aerh.flex_concatenated header_cost_center,
2620: aerd.report_line_id report_line_id,
2621: aerd.cost_center line_cost_center
2622: FROM
2623: ap_expense_report_headers_all aerh,
2624: ap_exp_report_dists_all aerd
2625: WHERE aerh.report_header_id = p_report_header_id
2626: AND aerd.report_header_id = aerh.report_header_id
2627: AND aerd.report_distribution_id = p_report_distribution_id;

Line 2860: from AP_EXPENSE_REPORT_HEADERS_ALL aerh,

2856: select rs.auto_approval_tag,
2857: rs.requires_audit_tag,
2858: rs.paperless_audit_tag,
2859: aerh.audit_code
2860: from AP_EXPENSE_REPORT_HEADERS_ALL aerh,
2861: AP_AUD_RULE_SETS rs,
2862: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
2863: where aerh.report_header_id = p_report_header_id
2864: and aerh.org_id = rsa.org_id

Line 2932: from ap_expense_report_headers_all aerh,

2928: AERH.AMT_DUE_EMPLOYEE,
2929: AI.Payment_status_flag,
2930: APS.GROSS_AMOUNT,
2931: AI.CANCELLED_DATE
2932: from ap_expense_report_headers_all aerh,
2933: AP_INVOICES_ALL AI,
2934: AP_PAYMENT_SCHEDULES_ALL APS
2935: where AI.INVOICE_ID(+) = AERH.VOUCHNO
2936: and APS.INVOICE_ID(+) = AI.INVOICE_ID