DBA Data[Home] [Help]

APPS.AP_APXINUPD_XMLP_PKG dependencies on AP_RECURRING_PAYMENTS_ALL

Line 508: AP_RECURRING_PAYMENTS_ALL ARP1

504: SELECT
505: COUNT(*)
506: INTO L_NUM_DUP_RECURRING
507: FROM
508: AP_RECURRING_PAYMENTS_ALL ARP1
509: WHERE VENDOR_ID = C_DUP_VENDOR_ID
510: AND VENDOR_SITE_ID = C_DUP_VENDOR_SITE_ID
511: AND EXISTS (
512: SELECT

Line 515: AP_RECURRING_PAYMENTS_ALL ARP2

511: AND EXISTS (
512: SELECT
513: 'this would be a duplicate'
514: FROM
515: AP_RECURRING_PAYMENTS_ALL ARP2
516: WHERE ARP2.VENDOR_ID = C_VENDOR_ID
517: AND ARP2.VENDOR_SITE_ID = C_VENDOR_SITE_ID
518: AND ARP2.RECURRING_PAY_NUM = ARP1.RECURRING_PAY_NUM );
519: RETURN (L_NUM_DUP_RECURRING);