DBA Data[Home] [Help]

APPS.ARP_PROC_RCT_UTIL dependencies on AR_RECEIPT_METHOD_ACCOUNTS

Line 2106: | ar_receipt_method_accounts for |

2102: | return all ccid's for the IN parameters |
2103: | 07-JAN-98 DJANCIS selected code combination id's for earned |
2104: | and unearnd ccids from |
2105: | ar_receivables_trx instead of |
2106: | ar_receipt_method_accounts for |
2107: | 11.5 VAT changes |
2108: | |
2109: +===========================================================================*/
2110:

Line 2128: ar_receivables_trx instead of ar_receipt_method_accounts for

2124: ) IS
2125: BEGIN
2126:
2127: /* selected code combination id's for earned and unearnd ccids from
2128: ar_receivables_trx instead of ar_receipt_method_accounts for
2129: 11.5 VAT changes */
2130:
2131: SELECT
2132: rma.unidentified_ccid,

Line 2154: AR_RECEIPT_METHOD_ACCOUNTS rma,

2150: p_confirmation_ccid,
2151: p_remittance_ccid,
2152: p_cash_ccid
2153: FROM
2154: AR_RECEIPT_METHOD_ACCOUNTS rma,
2155: AR_RECEIVABLES_TRX ed,
2156: AR_RECEIVABLES_TRX uned
2157: WHERE remit_bank_acct_use_id = p_remittance_bank_account_id
2158: AND receipt_method_id = p_receipt_method_id