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 183: ar_receipt_classes rc,

179: cr.customer_site_use_id,
180: pr.home_country
181: FROM ar_cash_receipts_all cr,
182: ar_receipt_methods rm,
183: ar_receipt_classes rc,
184: hz_cust_accounts hca,
185: hz_parties party,
186: /* Need to pass country code for SEPA specific receipts */
187: ce_bank_acct_uses bau,

Line 813: FROM ar_cash_receipts cr, ar_receipt_classes rc,

809:
810: ----get the status and payment method of of the receipt -----
811: SELECT rc.creation_status , nvl(rm.payment_channel_code, 'CHECK')
812: INTO l_cash_receipt_status, l_payment_type
813: FROM ar_cash_receipts cr, ar_receipt_classes rc,
814: ar_receipt_methods rm
815: WHERE cr.cash_receipt_id = l_cash_receipt_id
816: AND cr.receipt_method_id = rm.receipt_method_id
817: AND rm.receipt_class_id = rc.receipt_class_id;