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:
75: BEGIN

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

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

Line 231: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE;

227:
228: l_cr_rec ar_cash_receipts%ROWTYPE;
229: l_acctd_amount NUMBER;
230: l_receipt_clearing_ccid
231: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE;
232: l_batch_id ar_cash_receipt_history.batch_id%TYPE;
233: l_crh_id_rev
234: ar_cash_receipt_history.cash_receipt_history_id%TYPE;
235: l_dummy NUMBER; -- dummy variable

Line 1049: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE

1045: p_confirm_gl_date IN DATE,
1046: p_confirm_date IN DATE,
1047: p_acctd_amount IN NUMBER,
1048: p_receipt_clearing_ccid IN
1049: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE
1050: ) IS
1051: --
1052: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1053: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;

Line 1645: | ar_receipt_method_accounts table. |

1641: | get_receipt_clearing_ccid |
1642: | |
1643: | DESCRIPTION |
1644: | Determines the receipt clearing code combination id from the |
1645: | ar_receipt_method_accounts table. |
1646: | |
1647: | SCOPE - PRIVATE |
1648: | |
1649: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1670: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE

1666:
1667: PROCEDURE get_receipt_clearing_ccid(
1668: p_cr_rec IN ar_cash_receipts%ROWTYPE,
1669: p_receipt_clearing_ccid OUT NOCOPY
1670: ar_receipt_method_accounts.receipt_clearing_ccid%TYPE
1671: ) IS
1672:
1673: BEGIN
1674:

Line 1679: FROM ar_receipt_method_accounts rma

1675: arp_standard.debug('arp_confirmation.get_receipt_clearing_ccid()+');
1676:
1677: SELECT rma.receipt_clearing_ccid
1678: INTO p_receipt_clearing_ccid
1679: FROM ar_receipt_method_accounts rma
1680: WHERE rma.remit_bank_acct_use_id = p_cr_rec.remit_bank_acct_use_id
1681: AND rma.receipt_method_id = p_cr_rec.receipt_method_id;
1682:
1683: arp_standard.debug('arp_confirmation.get_receipt_clearing_ccid()-');