APPS.AP_WEB_EXPENSE_WF dependencies on AP_POL_VIOLATIONS

Line 777: FROM ap_pol_violations

773:
774: --Bug 3581975:Select the policy lines with distribution_line_number > 0.
775: SELECT count(*)
776: INTO l_violation_count
777: FROM ap_pol_violations
778: WHERE report_header_id = p_report_header_id
779: and distribution_line_number > 0;
780:
781: ------------------------------------------------------------

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

14235: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
14236: p_item_key,
14237: 'EXPENSE_REPORT_ID');
14238: ------------------------------------------------------
14239: l_debug_info := 'Select from ap_pol_violations table';
14240: ------------------------------------------------------
14241: --Bug 3581975:Select the policy lines with distribution_line_number > 0.
14242: SELECT count(*)
14243: INTO l_violations_count

Line 14244: FROM ap_pol_violations

14240: ------------------------------------------------------
14241: --Bug 3581975:Select the policy lines with distribution_line_number > 0.
14242: SELECT count(*)
14243: INTO l_violations_count
14244: FROM ap_pol_violations
14245: WHERE report_header_id = l_report_header_id
14246: and distribution_line_number > 0;
14247:
14248: IF (l_violations_count > 0) THEN