DBA Data[Home] [Help]

APPS.AP_PAYMENT_UTIL_PKG dependencies on AP_UNSELECTED_INVOICES_ALL

Line 184: FROM ap_unselected_invoices_All

180: BEGIN
181:
182: SELECT count(*)
183: INTO l_unsel_ps_count
184: FROM ap_unselected_invoices_All
185: WHERE checkrun_id = p_checkrun_id;
186: RETURN l_unsel_ps_count;
187:
188: END;

Line 238: FROM ap_unselected_invoices_all

234: BEGIN
235: IF p_dont_pay_code = 'OTHERS' THEN
236: SELECT count(*)
237: INTO l_count
238: FROM ap_unselected_invoices_all
239: WHERE checkrun_id = p_checkrun_id
240: AND dont_pay_reason_code NOT IN ('NEEDS_INVOICE_VALIDATION',
241: 'FAILED_INVOICE_VALIDATION',
242: 'ZERO INVOICE',

Line 253: FROM ap_unselected_invoices_all

249: ELSE
250:
251: SELECT count(*)
252: INTO l_count
253: FROM ap_unselected_invoices_all
254: WHERE checkrun_id = p_checkrun_id
255: AND dont_pay_reason_code = p_dont_pay_code;
256:
257: END IF;