eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

Line 456: from ap_pol_violations_all

452: FUNCTION get_allowable_amount(p_report_header_id IN NUMBER,
453: p_distribution_line_number IN NUMBER) RETURN NUMBER IS
454: CURSOR amount_cur IS
455: select min(allowable_amount) allowable_amount
456: from ap_pol_violations_all
457: where report_header_id = p_report_header_id
458: and distribution_line_number = p_distribution_line_number
459: and violation_type in ('DAILY_LIMIT','INDIVIDUAL_LIMIT');
460:

Line 507: from ap_pol_violations_all

503: FUNCTION get_allowable_cc_amount(p_report_header_id IN NUMBER,
504: p_distribution_line_number IN NUMBER) RETURN NUMBER IS
505: CURSOR amount_cur IS
506: select min(allowable_amount) allowable_cc_amount
507: from ap_pol_violations_all
508: where report_header_id = p_report_header_id
509: and distribution_line_number = p_distribution_line_number
510: and violation_type in ('CC_REQUIRED');
511:

Line 558: from ap_pol_violations_all

554: FUNCTION get_allowable_daily_sum(p_report_header_id IN NUMBER,
555: p_distribution_line_number IN NUMBER) RETURN NUMBER IS
556: CURSOR amount_cur IS
557: select min(allowable_amount) allowable_amount
558: from ap_pol_violations_all
559: where report_header_id = p_report_header_id
560: and distribution_line_number = p_distribution_line_number
561: and violation_type in ('DAILY_SUM_LIMIT');
562:

Line 619: AP_POL_VIOLATIONS_ALL pv

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