APPS.AP_WEB_AUDIT_UTILS dependencies on AP_POL_VIOLATIONS_ALL

Line 350: from AP_POL_VIOLATIONS_ALL

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'
354: order by violation_number;

Line 359: FROM ap_pol_violations_all

355:
356: CURSOR dup_violation_cur IS
357: SELECT violation_type, 'Duplicate Detection' violation,
358: dup_report_header_id, To_Char(dup_report_line_id) dup_report_line_id, dup_dist_line_number
359: FROM ap_pol_violations_all
360: WHERE report_header_id = p_report_header_id
361: AND distribution_line_number = p_distribution_line_number
362: AND violation_type = 'DUPLICATE_DETECTION'
363: ORDER BY violation_number;

Line 489: from ap_pol_violations_all

485: FUNCTION get_allowable_amount(p_report_header_id IN NUMBER,
486: p_distribution_line_number IN NUMBER) RETURN NUMBER IS
487: CURSOR amount_cur IS
488: select min(allowable_amount) allowable_amount
489: from ap_pol_violations_all
490: where report_header_id = p_report_header_id
491: and distribution_line_number = p_distribution_line_number
492: and violation_type in ('DAILY_LIMIT','INDIVIDUAL_LIMIT');
493:

Line 540: from ap_pol_violations_all

536: FUNCTION get_allowable_cc_amount(p_report_header_id IN NUMBER,
537: p_distribution_line_number IN NUMBER) RETURN NUMBER IS
538: CURSOR amount_cur IS
539: select min(allowable_amount) allowable_cc_amount
540: from ap_pol_violations_all
541: where report_header_id = p_report_header_id
542: and distribution_line_number = p_distribution_line_number
543: and violation_type in ('CC_REQUIRED');
544:

Line 591: from ap_pol_violations_all

587: FUNCTION get_allowable_daily_sum(p_report_header_id IN NUMBER,
588: p_distribution_line_number IN NUMBER) RETURN NUMBER IS
589: CURSOR amount_cur IS
590: select min(allowable_amount) allowable_amount
591: from ap_pol_violations_all
592: where report_header_id = p_report_header_id
593: and distribution_line_number = p_distribution_line_number
594: and violation_type in ('DAILY_SUM_LIMIT');
595:

Line 652: AP_POL_VIOLATIONS_ALL pv

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
656: and aerh.report_header_id = aerl.report_header_id