APPS.ARP_EXT_BANK_PKG dependencies on AR_RECEIPT_METHODS

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

864: p_as_of_date IN DATE DEFAULT TRUNC(SYSDATE)) RETURN NUMBER IS
865: TYPE pri_pay_method_typ IS REF CURSOR;
866:
867: pri_pay_method pri_pay_method_typ;
868: l_receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE := NULL;
869: l_site_use_id AP_BANK_ACCOUNT_USES.CUSTOMER_SITE_USE_ID%TYPE;
870: l_as_of_date DATE := NVL(p_as_of_date, TRUNC(SYSDATE));
871:
872: sql_stmt VARCHAR2(10000);

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

885: WHERE rm.customer_id = :p_customer_id
886: AND rm.SITE_USE_ID IS NULL
887: AND :p_as_of_date BETWEEN rm.start_date AND NVL(rm.end_date, :p_as_of_date ) ';
888:
889: cc_only_stmt VARCHAR2(4000) := ' AND EXISTS ( SELECT 1 FROM ar_receipt_methods ba
890: WHERE ba.RECEIPT_METHOD_ID = rm.RECEIPT_METHOD_ID
891: AND ba.payment_type_code = ''CREDIT_CARD'' ) ';
892: primary_stmt VARCHAR2(4000) := ' AND rm.primary_flag = ''Y'' ';
893: pay_stmt VARCHAR2(4000) := ' AND rm.receipt_method_id = :p_pay_method_id ';