APPS.AP_PAYMENT_UTIL_PKG dependencies on AP_SELECTED_INVOICES_ALL

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 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 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 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 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 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);