APPS.AP_WEB_EXPENSE_WF dependencies on AP_POL_VIOLATIONS

Line 760: FROM ap_pol_violations

756:
757: --Bug 3581975:Select the policy lines with distribution_line_number > 0.
758: SELECT count(*)
759: INTO l_violation_count
760: FROM ap_pol_violations
761: WHERE report_header_id = p_report_header_id
762: and distribution_line_number > 0;
763:
764: ------------------------------------------------------------

Line 13469: l_debug_info := 'Select from ap_pol_violations table';

13465: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
13466: p_item_key,
13467: 'EXPENSE_REPORT_ID');
13468: ------------------------------------------------------
13469: l_debug_info := 'Select from ap_pol_violations table';
13470: ------------------------------------------------------
13471: --Bug 3581975:Select the policy lines with distribution_line_number > 0.
13472: SELECT count(*)
13473: INTO l_violations_count

Line 13474: FROM ap_pol_violations

13470: ------------------------------------------------------
13471: --Bug 3581975:Select the policy lines with distribution_line_number > 0.
13472: SELECT count(*)
13473: INTO l_violations_count
13474: FROM ap_pol_violations
13475: WHERE report_header_id = l_report_header_id
13476: and distribution_line_number > 0;
13477:
13478: IF (l_violations_count > 0) THEN