APPS.AP_PAYMENT_UTIL_PKG dependencies on AP_SELECTED_INVOICES

Line 129: FROM ap_selected_invoices_All

125: l_selected_ps_count := 0;
126:
127: SELECT count(*)
128: INTO l_count1
129: FROM ap_selected_invoices_All
130: WHERE checkrun_id = p_checkrun_id
131: AND original_invoice_id is NULL
132: AND original_payment_num is NULL
133: AND ok_to_pay_flag = 'Y';

Line 267: FROM ap_selected_invoices_All asi,

263: BEGIN
264:
265: SELECT count(*)
266: INTO l_ps_ur_count
267: FROM ap_selected_invoices_All asi,
268: ap_system_parameters_all asp
269: WHERE asi.org_id = asp.org_id
270: AND asi.checkrun_id = p_checkrun_id
271: AND asp.base_currency_code = p_ledger_currency_code

Line 296: FROM ap_selected_invoices_all asi,

292: BEGIN
293:
294: SELECT count(*)
295: INTO l_missing_rates_ps_count
296: FROM ap_selected_invoices_all asi,
297: ap_system_parameters_all asp
298: WHERE asi.org_id = asp.org_id
299: AND asi.checkrun_id = p_checkrun_id
300: AND asp.base_currency_code <> asi.payment_currency_code

Line 336: FROM ap_selected_invoices_All

332:
333: BEGIN
334: SELECT payment_amount
335: INTO l_interest_due
336: FROM ap_selected_invoices_All
337: WHERE checkrun_id = p_checkrun_id
338: AND original_invoice_id = p_invoice_id
339: AND original_payment_num = p_payment_num;
340: EXCEPTION

Line 401: FROM ap_selected_invoices_All

397:
398: BEGIN
399: SELECT invoice_num
400: INTO l_interest_inv
401: FROM ap_selected_invoices_All
402: WHERE checkrun_id = p_checkrun_id
403: AND original_invoice_id = p_invoice_id
404: AND original_payment_num = p_payment_num;
405: EXCEPTION

Line 544: FROM ap_selected_invoices_All

540: l_function := 'AP_PAY_PSR_SEL_DOCS';
541:
542: SELECT count(*)
543: INTO l_count1
544: FROM ap_selected_invoices_All
545: WHERE checkrun_id = p_checkrun_id;
546:
547: SELECT count(*)
548: INTO l_count2

Line 549: FROM ap_selected_invoices

545: WHERE checkrun_id = p_checkrun_id;
546:
547: SELECT count(*)
548: INTO l_count2
549: FROM ap_selected_invoices
550: WHERE checkrun_id = p_checkrun_id;
551:
552: -- current user doesn't has access to all the selected docs
553: IF (l_count1 <> l_count2) THEN

Line 648: FROM ap_selected_invoices_All

644: IF l_action IN ('TakeActionEnabled') THEN
645: --
646: SELECT count(*)
647: INTO l_count1
648: FROM ap_selected_invoices_All
649: WHERE checkrun_id = p_checkrun_id;
650:
651: SELECT count(*)
652: INTO l_count2

Line 653: FROM ap_selected_invoices

649: WHERE checkrun_id = p_checkrun_id;
650:
651: SELECT count(*)
652: INTO l_count2
653: FROM ap_selected_invoices
654: WHERE checkrun_id = p_checkrun_id;
655:
656: -- current user doesn't has access to all the selected docs
657: IF (l_count1 <> l_count2) THEN

Line 717: FROM ap_selected_invoices_All

713:
714: IF l_function is NOT NULL THEN
715: SELECT count(*)
716: INTO l_count1
717: FROM ap_selected_invoices_All
718: WHERE checkrun_id = p_checkrun_id;
719:
720:
721: SELECT count(*)

Line 723: FROM ap_selected_invoices

719:
720:
721: SELECT count(*)
722: INTO l_count2
723: FROM ap_selected_invoices
724: WHERE checkrun_id = p_checkrun_id;
725:
726: -- current user doesn't has access to all the selected docs
727: IF (l_count1 <> l_count2) THEN

Line 783: FROM ap_selected_invoices_all ASI

779: UPDATE ap_payment_schedules_all APS
780: SET APS.checkrun_id = p_checkrun_id
781: WHERE (APS.invoice_id, APS.payment_num ) IN
782: (SELECT ASI.invoice_id, ASI.payment_num
783: FROM ap_selected_invoices_all ASI
784: WHERE APS.invoice_id = ASI.invoice_id
785: AND APS.payment_num = ASI.payment_num
786: AND ASI.checkrun_id = p_checkrun_id)
787: AND APS.checkrun_id is NULL;