DBA Data[Home] [Help]

APPS.ARP_PROC_RCT_UTIL dependencies on AR_RECEIPT_METHOD_ACCOUNTS

Line 2121: | ar_receipt_method_accounts for |

2117: | return all ccid's for the IN parameters |
2118: | 07-JAN-98 DJANCIS selected code combination id's for earned |
2119: | and unearnd ccids from |
2120: | ar_receivables_trx instead of |
2121: | ar_receipt_method_accounts for |
2122: | 11.5 VAT changes |
2123: | |
2124: +===========================================================================*/
2125:

Line 2143: ar_receivables_trx instead of ar_receipt_method_accounts for

2139: ) IS
2140: BEGIN
2141:
2142: /* selected code combination id's for earned and unearnd ccids from
2143: ar_receivables_trx instead of ar_receipt_method_accounts for
2144: 11.5 VAT changes */
2145:
2146: SELECT
2147: rma.unidentified_ccid,

Line 2169: AR_RECEIPT_METHOD_ACCOUNTS rma,

2165: p_confirmation_ccid,
2166: p_remittance_ccid,
2167: p_cash_ccid
2168: FROM
2169: AR_RECEIPT_METHOD_ACCOUNTS rma,
2170: AR_RECEIVABLES_TRX ed,
2171: AR_RECEIVABLES_TRX uned
2172: WHERE remit_bank_acct_use_id = p_remittance_bank_account_id
2173: AND receipt_method_id = p_receipt_method_id