APPS.OE_VERIFY_PAYMENT_PUB dependencies on RA_CUST_RECEIPT_METHODS

Line 4187: FROM ra_cust_receipt_methods rm

4183: --Changed the query to retrieve the receipt_method_id instead of
4184: --cust_receipt_method id as the pay method id corresponds to receipt_method_id
4185: SELECT receipt_method_id
4186: INTO l_pay_method_id
4187: FROM ra_cust_receipt_methods rm
4188: WHERE rm.customer_id = p_header_rec.sold_to_org_id
4189: AND rm.SITE_USE_ID = NVL( p_header_rec.invoice_to_org_id, -1)
4190: AND sysdate BETWEEN rm.start_date AND NVL(rm.end_date, sysdate)
4191: AND primary_flag = 'Y';

Line 4219: FROM ra_cust_receipt_methods rm

4215: --Changed the query to retrieve the receipt_method_id instead of
4216: --cust_receipt_method id as the pay method id corresponds to receipt_method_id
4217: SELECT receipt_method_id
4218: INTO l_pay_method_id
4219: FROM ra_cust_receipt_methods rm
4220: WHERE rm.customer_id = p_header_rec.sold_to_org_id
4221: AND rm.SITE_USE_ID IS NULL
4222: AND sysdate BETWEEN rm.start_date AND NVL(rm.end_date, sysdate)
4223: AND primary_flag = 'Y';