[Home] [Help]
345: FUNCTION get_line_status(p_report_header_id IN NUMBER,
346: p_distribution_line_number IN NUMBER) RETURN VARCHAR2 IS
347: CURSOR violation_cur IS
348: select violation_type,
349: AP_WEB_POLICY_UTILS.get_lookup_meaning('OIE_POL_VIOLATION_TYPES',violation_type) violation
350: from AP_POL_VIOLATIONS_ALL
351: where report_header_id = p_report_header_id
352: and distribution_line_number = p_distribution_line_number
353: AND violation_type <> 'DUPLICATE_DETECTION'
1260: FUNCTION get_audit_reason(p_report_header_id IN NUMBER) RETURN VARCHAR2 IS
1261:
1262: CURSOR audit_cur IS
1263: select audit_reason_code,
1264: AP_WEB_POLICY_UTILS.get_lookup_meaning('OIE_AUDIT_REASONS',audit_reason_code) audit_reason
1265: from AP_AUD_AUDIT_REASONS
1266: where report_header_id = p_report_header_id
1267: order by audit_reason_id;
1268:
1785: AND aerh.org_id = site.org_id
1786: AND aerh.org_id = fp.org_id
1787: AND site.vendor_id = vdr.vendor_id
1788: AND vdr.employee_id = aerh.employee_id
1789: AND upper(site.vendor_site_code) = UPPER(AP_WEB_POLICY_UTILS.get_lookup_meaning('HOME_OFFICE', fp.expense_check_address_flag));
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,
2817: ap_pol_headers ph,
2818: ap_expense_report_params_all erp
2819: where aerl.report_header_id = p_report_header_id
2820: and aerl.distribution_line_number = p_distribution_line_number
2821: and aerl.category_code = AP_WEB_POLICY_UTILS.c_PER_DIEM
2822: and erp.parameter_id = aerl.web_parameter_id
2823: and ph.policy_id = erp.company_policy_id;
2824:
2825: pdm_rec pdm_cur%ROWTYPE;