DBA Data[Home] [Help]

APPS.ARI_SELF_REG_CONFIG dependencies on AR_CASH_RECEIPTS

Line 133: FROM ar_cash_receipts

129: BEGIN
130: --Select a receipt at this customer site
131: SELECT receipt_number
132: INTO l_receipt_number
133: FROM ar_cash_receipts
134: WHERE PAY_FROM_CUSTOMER = p_customer_id
135: AND customer_site_use_id = nvl(p_customer_site_use_id,customer_site_use_id)
136: AND currency_code = 'USD'
137: AND rownum = 1;

Line 157: FROM ar_cash_receipts

153: BEGIN
154: --Set the expected answer
155: SELECT amount
156: INTO l_temp
157: FROM ar_cash_receipts
158: WHERE PAY_FROM_CUSTOMER = p_customer_id
159: AND customer_site_use_id = nvl(p_customer_site_use_id,customer_site_use_id)
160: AND currency_code = 'USD'
161: AND rownum = 1;