APPS.AP_WEB_AUDIT_PROCESS dependencies on AP_POL_VIOLATIONS_ALL

Line 608: from ap_pol_violations_all pv

604: and ( NVL(aerl.justification_required_flag,'N') = 'Y'
605: OR (
606: NVL(aerl.justification_required_flag,'N') = 'V'
607: AND EXISTS(select 1
608: from ap_pol_violations_all pv
609: where pv.report_header_id = aerl.report_header_id
610: and pv.distribution_line_number = aerl.distribution_line_number
611: )
612: )

Line 1564: from AP_POL_VIOLATIONS_ALL

1560: FUNCTION get_report_violation_count(p_report_header_id IN NUMBER) RETURN NUMBER IS
1561:
1562: CURSOR violation_cur IS
1563: select count(1) violation_count
1564: from AP_POL_VIOLATIONS_ALL
1565: where report_header_id = p_report_header_id;
1566:
1567: violation_rec violation_cur%ROWTYPE;
1568:

Line 1607: from AP_POL_VIOLATIONS_ALL viol,

1603: p_months IN NUMBER) RETURN NUMBER IS
1604:
1605: CURSOR violation_cur IS
1606: select count(1) violation_count
1607: from AP_POL_VIOLATIONS_ALL viol,
1608: AP_EXPENSE_REPORT_HEADERS_ALL aerh
1609: where aerh.employee_id = p_employee_id
1610: and viol.report_header_id = aerh.report_header_id
1611: and aerh.week_end_date > add_months(sysdate,-p_months);