DBA Data[Home] [Help]

APPS.ARI_SELF_REG_CONFIG dependencies on AR_CASH_RECEIPTS

Line 193: FROM ar_cash_receipts

189: BEGIN
190: --Select a receipt at this customer site
191: SELECT receipt_number
192: INTO l_receipt_number
193: FROM ar_cash_receipts
194: WHERE PAY_FROM_CUSTOMER = p_customer_id
195: AND customer_site_use_id = nvl(p_customer_site_use_id,customer_site_use_id)
196: AND rownum = 1;
197: EXCEPTION

Line 216: FROM ar_cash_receipts

212: BEGIN
213: --Set the expected answer
214: SELECT amount
215: INTO l_temp
216: FROM ar_cash_receipts
217: WHERE PAY_FROM_CUSTOMER = p_customer_id
218: AND customer_site_use_id = nvl(p_customer_site_use_id,customer_site_use_id)
219: AND rownum = 1;
220: