DBA Data[Home] [Help]

APPS.AP_PAYMENT_UTIL_PKG dependencies on AP_UNSELECTED_INVOICES_ALL

Line 166: FROM ap_unselected_invoices_All

162: BEGIN
163:
164: SELECT count(*)
165: INTO l_unsel_ps_count
166: FROM ap_unselected_invoices_All
167: WHERE checkrun_id = p_checkrun_id;
168: RETURN l_unsel_ps_count;
169:
170: END;

Line 220: FROM ap_unselected_invoices_all

216: BEGIN
217: IF p_dont_pay_code = 'OTHERS' THEN
218: SELECT count(*)
219: INTO l_count
220: FROM ap_unselected_invoices_all
221: WHERE checkrun_id = p_checkrun_id
222: AND dont_pay_reason_code NOT IN ('NEEDS_INVOICE_VALIDATION',
223: 'FAILED_INVOICE_VALIDATION',
224: 'ZERO INVOICE',

Line 235: FROM ap_unselected_invoices_all

231: ELSE
232:
233: SELECT count(*)
234: INTO l_count
235: FROM ap_unselected_invoices_all
236: WHERE checkrun_id = p_checkrun_id
237: AND dont_pay_reason_code = p_dont_pay_code;
238:
239: END IF;