APPS.OE_VERIFY_PAYMENT_PUB dependencies on RA_CUST_RECEIPT_METHODS

Line 4114: FROM ra_cust_receipt_methods rm

4110: --Changed the query to retrieve the receipt_method_id instead of
4111: --cust_receipt_method id as the pay method id corresponds to receipt_method_id
4112: SELECT receipt_method_id
4113: INTO l_pay_method_id
4114: FROM ra_cust_receipt_methods rm
4115: WHERE rm.customer_id = p_header_rec.sold_to_org_id
4116: AND rm.SITE_USE_ID = NVL( p_header_rec.invoice_to_org_id, -1)
4117: AND sysdate BETWEEN rm.start_date AND NVL(rm.end_date, sysdate)
4118: AND primary_flag = 'Y';

Line 4146: FROM ra_cust_receipt_methods rm

4142: --Changed the query to retrieve the receipt_method_id instead of
4143: --cust_receipt_method id as the pay method id corresponds to receipt_method_id
4144: SELECT receipt_method_id
4145: INTO l_pay_method_id
4146: FROM ra_cust_receipt_methods rm
4147: WHERE rm.customer_id = p_header_rec.sold_to_org_id
4148: AND rm.SITE_USE_ID IS NULL
4149: AND sysdate BETWEEN rm.start_date AND NVL(rm.end_date, sysdate)
4150: AND primary_flag = 'Y';