APPS.AP_WEB_AUDIT_PROCESS dependencies on AP_POL_VIOLATIONS_ALL

Line 669: from ap_pol_violations_all pv

665: and (( NVL(aerl.justification_required_flag,'N') = 'Y'
666: OR (
667: NVL(aerl.justification_required_flag,'N') = 'V'
668: AND EXISTS(select 1
669: from ap_pol_violations_all pv
670: where pv.report_header_id = aerl.report_header_id
671: and pv.distribution_line_number = aerl.distribution_line_number
672: )
673: )

Line 1681: from AP_POL_VIOLATIONS_ALL

1677: FUNCTION get_report_violation_count(p_report_header_id IN NUMBER) RETURN NUMBER IS
1678:
1679: CURSOR violation_cur IS
1680: select count(1) violation_count
1681: from AP_POL_VIOLATIONS_ALL
1682: where report_header_id = p_report_header_id;
1683:
1684: violation_rec violation_cur%ROWTYPE;
1685:

Line 1724: from AP_POL_VIOLATIONS_ALL viol,

1720: p_months IN NUMBER) RETURN NUMBER IS
1721:
1722: CURSOR violation_cur IS
1723: select count(1) violation_count
1724: from AP_POL_VIOLATIONS_ALL viol,
1725: AP_EXPENSE_REPORT_HEADERS_ALL aerh
1726: where aerh.employee_id = p_employee_id
1727: and viol.report_header_id = aerh.report_header_id
1728: and aerh.week_end_date > add_months(sysdate,-p_months);