DBA Data[Home] [Help]

APPS.ARP_REVERSE_RECEIPT dependencies on AR_RECEIPT_METHODS

Line 169: l_rm_code ar_receipt_methods.payment_type_code%TYPE;

165: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
166: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
167: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
168: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
169: l_rm_code ar_receipt_methods.payment_type_code%TYPE;
170: l_rt_type ar_receivables_trx.type%TYPE;
171:
172: --
173: l_gl_date_closed DATE;

Line 244: CURSOR ar_rm_C(p_receipt_method_id ar_receipt_methods.receipt_method_id%TYPE) is

240: AND ra.application_ref_type = 'MISC_RECEIPT';
241:
242: --
243: /* CCRR-need to find the receipt payment type code to determine if the MISC receipt is of type Credit_card pkt*/
244: CURSOR ar_rm_C(p_receipt_method_id ar_receipt_methods.receipt_method_id%TYPE) is
245: Select payment_channel_code
246: FROM ar_receipt_methods
247: where receipt_method_id = p_receipt_method_id;
248:

Line 246: FROM ar_receipt_methods

242: --
243: /* CCRR-need to find the receipt payment type code to determine if the MISC receipt is of type Credit_card pkt*/
244: CURSOR ar_rm_C(p_receipt_method_id ar_receipt_methods.receipt_method_id%TYPE) is
245: Select payment_channel_code
246: FROM ar_receipt_methods
247: where receipt_method_id = p_receipt_method_id;
248:
249: BEGIN
250: IF PG_DEBUG in ('Y', 'C') THEN

Line 1595: l_receipt_method_name ar_receipt_methods.name%TYPE;

1591: p_status IN OUT NOCOPY VARCHAR2,
1592: p_module_name IN VARCHAR2,
1593: p_module_version IN VARCHAR2 ) IS
1594:
1595: l_receipt_method_name ar_receipt_methods.name%TYPE;
1596: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
1597: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1598:
1599: l_currency_code ar_cash_receipts.currency_code%TYPE;

Line 1745: ar_receipt_methods rm

1741: l_amount,
1742: l_dm_inherit_rcpt_num_flag,
1743: l_legal_entity_id --5126184
1744: FROM
1745: ar_receipt_methods rm
1746: , ar_cash_receipts cr
1747: WHERE cr.cash_receipt_id = l_cr_id
1748: AND rm.receipt_method_id = cr.receipt_method_id;
1749: --