APPS.ARP_EXT_BANK_PKG dependencies on AR_RECEIPT_METHODS

Line 889: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE := NULL;

885: p_as_of_date IN DATE DEFAULT TRUNC(SYSDATE)) RETURN NUMBER IS
886: TYPE pri_pay_method_typ IS REF CURSOR;
887:
888: pri_pay_method pri_pay_method_typ;
889: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE := NULL;
890: l_site_use_id AP_BANK_ACCOUNT_USES.CUSTOMER_SITE_USE_ID%TYPE;
891: l_as_of_date DATE := NVL(p_as_of_date, TRUNC(SYSDATE));
892:
893: sql_stmt VARCHAR2(10000);

Line 910: cc_only_stmt VARCHAR2(4000) := ' AND EXISTS ( SELECT 1 FROM ar_receipt_methods ba

906: WHERE rm.customer_id = :p_customer_id
907: AND rm.SITE_USE_ID IS NULL
908: AND :p_as_of_date BETWEEN rm.start_date AND NVL(rm.end_date, :p_as_of_date ) ';
909:
910: cc_only_stmt VARCHAR2(4000) := ' AND EXISTS ( SELECT 1 FROM ar_receipt_methods ba
911: WHERE ba.RECEIPT_METHOD_ID = rm.RECEIPT_METHOD_ID
912: AND ba.payment_channel_code = ''CREDIT_CARD'' ) '; /* Bug 14319639 */
913: primary_stmt VARCHAR2(4000) := ' AND rm.primary_flag = ''Y'' ';
914: pay_stmt VARCHAR2(4000) := ' AND rm.receipt_method_id = :p_pay_method_id ';