APPS.ARP_CONFIRMATION dependencies on AR_RECEIPT_METHOD_ACCOUNTS

Line 71: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE;

67: -- local variables:
68:
69: l_acctd_amount NUMBER;
70: l_receipt_clearing_ccid
71: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE;
72: l_dummy NUMBER;
73: l_cr_rec ar_cash_receipts%ROWTYPE;
74: l_xla_ev_rec arp_xla_events.xla_events_type;
75:

Line 106: -- get receipt clearing code combination id from ar_receipt_method_accounts

102: IF PG_DEBUG in ('Y', 'C') THEN
103: arp_standard.debug('confirm: ' || '-- Cash Receipt fetched');
104: END IF;
105:
106: -- get receipt clearing code combination id from ar_receipt_method_accounts
107:
108: get_receipt_clearing_ccid(l_cr_rec, l_receipt_clearing_ccid);
109:
110: IF PG_DEBUG in ('Y', 'C') THEN

Line 248: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE;

244:
245: l_cr_rec ar_cash_receipts%ROWTYPE;
246: l_acctd_amount NUMBER;
247: l_receipt_clearing_ccid
248: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE;
249: l_batch_id ar_cash_receipt_history.batch_id%TYPE;
250: l_crh_id_rev
251: ar_cash_receipt_history.cash_receipt_history_id%TYPE;
252: l_dummy NUMBER; -- dummy variable

Line 1066: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE

1062: p_confirm_gl_date IN DATE,
1063: p_confirm_date IN DATE,
1064: p_acctd_amount IN NUMBER,
1065: p_receipt_clearing_ccid IN
1066: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE
1067: ) IS
1068: --
1069: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1070: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;

Line 1662: | ar_receipt_method_accounts table. |

1658: | get_receipt_clearing_ccid |
1659: | |
1660: | DESCRIPTION |
1661: | Determines the receipt clearing code combination id from the |
1662: | ar_receipt_method_accounts table. |
1663: | |
1664: | SCOPE - PRIVATE |
1665: | |
1666: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1687: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE

1683:
1684: PROCEDURE get_receipt_clearing_ccid(
1685: p_cr_rec IN ar_cash_receipts%ROWTYPE,
1686: p_receipt_clearing_ccid OUT NOCOPY
1687: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE
1688: ) IS
1689:
1690: BEGIN
1691:

Line 1696: FROM ar_receipt_method_accounts rma

1692: arp_standard.debug('arp_confirmation.get_receipt_clearing_ccid()+');
1693:
1694: SELECT rma.receipt_clearing_ccid
1695: INTO p_receipt_clearing_ccid
1696: FROM ar_receipt_method_accounts rma
1697: WHERE rma.remit_bank_acct_use_id = p_cr_rec.remit_bank_acct_use_id
1698: AND rma.receipt_method_id = p_cr_rec.receipt_method_id;
1699:
1700: arp_standard.debug('arp_confirmation.get_receipt_clearing_ccid()-');