APPS.AP_PAYMENT_UTIL_PKG dependencies on AP_SELECTED_INVOICES

Line 146: FROM ap_selected_invoices_All

142: l_selected_ps_count := 0;
143:
144: SELECT count(*)
145: INTO l_count1
146: FROM ap_selected_invoices_All
147: WHERE checkrun_id = p_checkrun_id
148: AND original_invoice_id is NULL
149: AND original_payment_num is NULL
150: AND ok_to_pay_flag = 'Y';

Line 285: FROM ap_selected_invoices_All asi,

281: BEGIN
282:
283: SELECT count(*)
284: INTO l_ps_ur_count
285: FROM ap_selected_invoices_All asi,
286: ap_system_parameters_all asp
287: WHERE asi.org_id = asp.org_id
288: AND asi.checkrun_id = p_checkrun_id
289: AND asp.base_currency_code = p_ledger_currency_code

Line 314: FROM ap_selected_invoices_all asi,

310: BEGIN
311:
312: SELECT count(*)
313: INTO l_missing_rates_ps_count
314: FROM ap_selected_invoices_all asi,
315: ap_system_parameters_all asp
316: WHERE asi.org_id = asp.org_id
317: AND asi.checkrun_id = p_checkrun_id
318: AND asp.base_currency_code <> asi.payment_currency_code

Line 354: FROM ap_selected_invoices_All

350:
351: BEGIN
352: SELECT payment_amount
353: INTO l_interest_due
354: FROM ap_selected_invoices_All
355: WHERE checkrun_id = p_checkrun_id
356: AND original_invoice_id = p_invoice_id
357: AND original_payment_num = p_payment_num;
358: EXCEPTION

Line 419: FROM ap_selected_invoices_All

415:
416: BEGIN
417: SELECT invoice_num
418: INTO l_interest_inv
419: FROM ap_selected_invoices_All
420: WHERE checkrun_id = p_checkrun_id
421: AND original_invoice_id = p_invoice_id
422: AND original_payment_num = p_payment_num;
423: EXCEPTION

Line 564: FROM ap_selected_invoices_All

560:
561: /* Code Added for Bug#9276224 Start */
562: SELECT count(*)
563: INTO l_count1
564: FROM ap_selected_invoices_All
565: WHERE checkrun_id = p_checkrun_id;
566:
567: SELECT count(*)
568: INTO l_count2

Line 569: FROM ap_selected_invoices

565: WHERE checkrun_id = p_checkrun_id;
566:
567: SELECT count(*)
568: INTO l_count2
569: FROM ap_selected_invoices
570: WHERE checkrun_id = p_checkrun_id;
571:
572: -- current user doesn't has access to all the selected docs
573: IF (l_count1 <> l_count2) THEN

Line 607: FROM ap_selected_invoices_All

603:
604: /* commented for bug#9276224 Start
605: SELECT count(*)
606: INTO l_count1
607: FROM ap_selected_invoices_All
608: WHERE checkrun_id = p_checkrun_id;
609:
610: SELECT count(*)
611: INTO l_count2

Line 612: FROM ap_selected_invoices

608: WHERE checkrun_id = p_checkrun_id;
609:
610: SELECT count(*)
611: INTO l_count2
612: FROM ap_selected_invoices
613: WHERE checkrun_id = p_checkrun_id;
614:
615: -- current user doesn't has access to all the selected docs
616: IF (l_count1 <> l_count2) THEN

Line 672: FROM ap_selected_invoices_All

668:
669: /* Added for bug#9276224 Start */
670: SELECT count(*)
671: INTO l_count1
672: FROM ap_selected_invoices_All
673: WHERE checkrun_id = p_checkrun_id;
674:
675: SELECT count(*)
676: INTO l_count2

Line 677: FROM ap_selected_invoices

673: WHERE checkrun_id = p_checkrun_id;
674:
675: SELECT count(*)
676: INTO l_count2
677: FROM ap_selected_invoices
678: WHERE checkrun_id = p_checkrun_id;
679:
680: -- current user doesn't has access to all the selected docs
681: IF (l_count1 <> l_count2) THEN

Line 731: FROM ap_selected_invoices_All

727: IF l_action IN ('TakeActionEnabled') THEN
728: --
729: SELECT count(*)
730: INTO l_count1
731: FROM ap_selected_invoices_All
732: WHERE checkrun_id = p_checkrun_id;
733:
734: SELECT count(*)
735: INTO l_count2

Line 736: FROM ap_selected_invoices

732: WHERE checkrun_id = p_checkrun_id;
733:
734: SELECT count(*)
735: INTO l_count2
736: FROM ap_selected_invoices
737: WHERE checkrun_id = p_checkrun_id;
738:
739: -- current user doesn't has access to all the selected docs
740: IF (l_count1 <> l_count2) THEN

Line 801: FROM ap_selected_invoices_All

797:
798: IF l_function is NOT NULL THEN
799: SELECT count(*)
800: INTO l_count1
801: FROM ap_selected_invoices_All
802: WHERE checkrun_id = p_checkrun_id;
803:
804:
805: SELECT count(*)

Line 807: FROM ap_selected_invoices

803:
804:
805: SELECT count(*)
806: INTO l_count2
807: FROM ap_selected_invoices
808: WHERE checkrun_id = p_checkrun_id;
809:
810: -- current user doesn't has access to all the selected docs
811: IF (l_count1 <> l_count2) THEN

Line 867: FROM ap_selected_invoices_all ASI

863: UPDATE ap_payment_schedules_all APS
864: SET APS.checkrun_id = p_checkrun_id
865: WHERE (APS.invoice_id, APS.payment_num ) IN
866: (SELECT ASI.invoice_id, ASI.payment_num
867: FROM ap_selected_invoices_all ASI
868: WHERE APS.invoice_id = ASI.invoice_id
869: AND APS.payment_num = ASI.payment_num
870: AND ASI.checkrun_id = p_checkrun_id)
871: AND APS.checkrun_id is NULL;

Line 1272: FROM AP_SELECTED_INVOICES_ALL

1268: RETURN VARCHAR2 IS
1269:
1270: CURSOR C_GET_ORG_INFO IS
1271: SELECT DISTINCT ORG_ID
1272: FROM AP_SELECTED_INVOICES_ALL
1273: WHERE CHECKRUN_ID = p_checkrun_id
1274: and NVL(MO_GLOBAL.CHECK_ACCESS(ORG_ID), 'N') <> 'Y';
1275:
1276: l_return_val VARCHAR2(1);