APPS.AR_PREPAYMENTS_PUB dependencies on AR_RECEIPT_METHODS

Line 96: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,

92: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
93: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
94: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
95: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
96: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
97: p_doc_sequence_value IN NUMBER DEFAULT NULL,
98: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
99: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
100: p_called_from IN VARCHAR2 DEFAULT NULL,

Line 161: l_payment_type ar_receipt_methods.payment_type_code%type;

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;
165: l_org_return_status VARCHAR2(1);

Line 181: ar_receipt_methods rm,

177: party.party_id,
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

Line 284: FROM ar_receipt_methods

280: /*--------------------------------------------------------------------
281: IF p_receipt_method_id is not null THEN
282: BEGIN
283: SELECT 'Y' into l_cc_check
284: FROM ar_receipt_methods
285: WHERE receipt_method_id=p_receipt_method_id
286: AND payment_type_code = 'CREDIT_CARD';
287: EXCEPTION
288: WHEN no_data_found THEN

Line 436: FROM ar_receipt_methods

432:
433:
434: SELECT payment_channel_code
435: INTO l_payment_type
436: FROM ar_receipt_methods
437: WHERE receipt_method_id = p_receipt_method_id;
438:
439:
440: l_payment_trxn_extension_id := p_payment_trxn_extension_id;

Line 799: ar_receipt_methods rm

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;
803: