APPS.AR_PREPAYMENTS_PUB dependencies on AR_RECEIPT_CLASSES

Line 160: l_cash_receipt_status ar_receipt_classes.creation_status%type;

156: l_receivables_trx_id NUMBER;
157: l_response_error_code VARCHAR2(80);
158:
159: --Bug 3220078 --
160: l_cash_receipt_status ar_receipt_classes.creation_status%type;
161: l_payment_type ar_receipt_methods.payment_type_code%type;
162:
163: l_api_name CONSTANT VARCHAR2(20) := 'Create_Prepayment';
164: l_api_version CONSTANT NUMBER := 1.0;

Line 182: ar_receipt_classes rc,

178: cr.pay_from_customer,
179: cr.customer_site_use_id
180: FROM ar_cash_receipts_all cr,
181: ar_receipt_methods rm,
182: ar_receipt_classes rc,
183: hz_cust_accounts hca,
184: hz_parties party
185: WHERE cr.cash_receipt_id = l_cash_receipt_id
186: AND hca.party_id = party.party_id

Line 798: FROM ar_cash_receipts cr, ar_receipt_classes rc,

794:
795: ----get the status and payment method of of the receipt -----
796: SELECT rc.creation_status , nvl(rm.payment_channel_code, 'CHECK')
797: INTO l_cash_receipt_status, l_payment_type
798: FROM ar_cash_receipts cr, ar_receipt_classes rc,
799: ar_receipt_methods rm
800: WHERE cr.cash_receipt_id = l_cash_receipt_id
801: AND cr.receipt_method_id = rm.receipt_method_id
802: AND rm.receipt_class_id = rc.receipt_class_id;