APPS.AP_WEB_AME_PKG dependencies on AP_POL_VIOLATIONS_ALL

Line 40: from ap_pol_violations_all

36: l_debug_info := 'Start getViolationTotal';
37: -----------------------------------------------------
38: select sum(exceeded_amount)
39: into l_violation_total
40: from ap_pol_violations_all
41: where report_header_id = p_report_header_id;
42:
43: -----------------------------------------------------
44: l_debug_info := 'Get extra amount';

Line 55: from ap_pol_violations_all viol1, ap_pol_violations_all viol2

51: */
52:
53: select nvl(sum(least(viol1.exceeded_amount, viol2.exceeded_amount)), 0)
54: into l_extra_amount
55: from ap_pol_violations_all viol1, ap_pol_violations_all viol2
56: where viol1.report_header_id = viol2.report_header_id
57: and viol1.distribution_line_number = viol2.distribution_line_number
58: and viol1.violation_type = 'DAILY_LIMIT'
59: and viol2.violation_type = 'DAILY_SUM_LIMIT'