APPS.AP_WEB_AUDIT_UTILS dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

Line 651: AP_EXPENSE_REPORT_HEADERS_ALL aerh,

647: eo.overall_tolerance,
648: eo.org_id
649: from AP_POL_EXRATE_OPTIONS_ALL eo,
650: AP_EXPENSE_REPORT_LINES_ALL aerl,
651: AP_EXPENSE_REPORT_HEADERS_ALL aerh,
652: AP_POL_VIOLATIONS_ALL pv
653: where aerl.report_header_id = pv.report_header_id
654: and aerl.distribution_line_number = pv.distribution_line_number
655: and aerl.credit_card_trx_id is null

Line 1383: from AP_EXPENSE_REPORT_HEADERS_ALL aerh

1379: PROCEDURE set_audit_list_member(p_report_header_id IN NUMBER, p_reason_code IN VARCHAR2) IS
1380:
1381: CURSOR report_cur IS
1382: select aerh.employee_id, aerh.org_id
1383: from AP_EXPENSE_REPORT_HEADERS_ALL aerh
1384: where aerh.report_header_id = p_report_header_id;
1385:
1386: CURSOR required_cur IS
1387: select count(1) required_count

Line 1782: ap_expense_report_headers_all aerh,

1778: CURSOR site_cur IS
1779: SELECT site.invoice_currency_code default_currency_code
1780: FROM ap_suppliers vdr,
1781: ap_supplier_sites_all site,
1782: ap_expense_report_headers_all aerh,
1783: financials_system_params_all fp
1784: WHERE aerh.report_header_id = p_report_header_id
1785: AND aerh.org_id = site.org_id
1786: AND aerh.org_id = fp.org_id

Line 1794: ap_expense_report_headers_all aerh,

1790:
1791: CURSOR vendor_cur IS
1792: SELECT nvl(vdr.invoice_currency_code,sp.base_currency_code) default_currency_code
1793: FROM ap_suppliers vdr,
1794: ap_expense_report_headers_all aerh,
1795: ap_system_parameters_all sp
1796: WHERE vdr.employee_id = aerh.employee_id
1797: AND aerh.report_header_id = p_report_header_id
1798: AND aerh.org_id = sp.org_id;

Line 1804: ap_expense_report_headers_all aerh,

1800: CURSOR advance_cur(p_default_currency_code IN VARCHAR2) IS
1801: SELECT get_available_prepays(vdr.vendor_id) advance_count,
1802: aerh.employee_id
1803: FROM ap_invoices_all i,
1804: ap_expense_report_headers_all aerh,
1805: ap_suppliers vdr
1806: WHERE i.vendor_id = vdr.vendor_id
1807: AND aerh.report_header_id = p_report_header_id
1808: AND vdr.employee_id = aerh.employee_id

Line 1817: FROM ap_expense_report_headers_all aerh

1813: AND ROWNUM = 1;
1814:
1815: CURSOR applied_cur(p_employee_id NUMBER, p_default_currency_code IN VARCHAR2) IS
1816: SELECT nvl(sum(maximum_amount_to_apply),0) applied_prepayment
1817: FROM ap_expense_report_headers_all aerh
1818: WHERE aerh.employee_id = p_employee_id
1819: AND aerh.vouchno = 0
1820: AND aerh.default_currency_code = p_default_currency_code
1821: GROUP BY aerh.employee_id;

Line 2665: ap_expense_report_headers_all aerh,

2661: aerh.flex_concatenated header_cost_center,
2662: aerd.report_line_id report_line_id,
2663: aerd.cost_center line_cost_center
2664: FROM
2665: ap_expense_report_headers_all aerh,
2666: ap_exp_report_dists_all aerd
2667: WHERE aerh.report_header_id = p_report_header_id
2668: AND aerd.report_header_id = aerh.report_header_id
2669: AND aerd.report_distribution_id = p_report_distribution_id;

Line 2907: from AP_EXPENSE_REPORT_HEADERS_ALL aerh,

2903: nvl(rs.aud_img_receipt_required,'X') aud_img_receipt_required,
2904: nvl(rs.aud_paper_receipt_required, 'X') aud_paper_receipt_required,
2905: nvl(aerh.image_receipts_status,'NOT_REQUIRED') hdr_img_receipt_required,
2906: nvl(aerh.receipts_status,'NOT_REQUIRED') hdr_paper_receipt_required
2907: from AP_EXPENSE_REPORT_HEADERS_ALL aerh,
2908: AP_AUD_RULE_SETS rs,
2909: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
2910: where aerh.report_header_id = p_report_header_id
2911: and aerh.org_id = rsa.org_id

Line 2981: from ap_expense_report_headers_all aerh,

2977: AERH.AMT_DUE_EMPLOYEE,
2978: AI.Payment_status_flag,
2979: APS.GROSS_AMOUNT,
2980: AI.CANCELLED_DATE
2981: from ap_expense_report_headers_all aerh,
2982: AP_INVOICES_ALL AI,
2983: AP_PAYMENT_SCHEDULES_ALL APS
2984: where AI.INVOICE_ID(+) = AERH.VOUCHNO
2985: and APS.INVOICE_ID(+) = AI.INVOICE_ID