[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: order by violation_number;
1221: FUNCTION get_audit_reason(p_report_header_id IN NUMBER) RETURN VARCHAR2 IS
1222:
1223: CURSOR audit_cur IS
1224: select audit_reason_code,
1225: AP_WEB_POLICY_UTILS.get_lookup_meaning('OIE_AUDIT_REASONS',audit_reason_code) audit_reason
1226: from AP_AUD_AUDIT_REASONS
1227: where report_header_id = p_report_header_id
1228: order by audit_reason_id;
1229:
1743: AND aerh.org_id = site.org_id
1744: AND aerh.org_id = fp.org_id
1745: AND site.vendor_id = vdr.vendor_id
1746: AND vdr.employee_id = aerh.employee_id
1747: AND upper(site.vendor_site_code) = UPPER(AP_WEB_POLICY_UTILS.get_lookup_meaning('HOME_OFFICE', fp.expense_check_address_flag));
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,
2775: ap_pol_headers ph,
2776: ap_expense_report_params_all erp
2777: where aerl.report_header_id = p_report_header_id
2778: and aerl.distribution_line_number = p_distribution_line_number
2779: and aerl.category_code = AP_WEB_POLICY_UTILS.c_PER_DIEM
2780: and erp.parameter_id = aerl.web_parameter_id
2781: and ph.policy_id = erp.company_policy_id;
2782:
2783: pdm_rec pdm_cur%ROWTYPE;