APPS.ARP_CASH_BASIS_ACCOUNTING dependencies on AR_CASH_RECEIPT_HISTORY

Line 1712: ar_cash_receipt_history crh,

1708: FROM ar_receivable_applications ra,
1709: ra_cust_trx_types ctt,
1710: ra_customer_trx ct,
1711: ar_cash_receipts cr,
1712: ar_cash_receipt_history crh,
1713: ra_customer_trx ctcm,
1714: ar_lookups l
1715: WHERE ra.posting_control_id = p_Post.UnpostedPostingControlId
1716: AND ra.gl_date BETWEEN p_Post.GlDateFrom

Line 2048: FROM ar_cash_receipt_history crh,

2044: cr.doc_sequence_id DocSequenceId,
2045: cr.doc_sequence_value DocSequenceValue,
2046: cr.ussgl_transaction_code UssglTransactionCode,
2047: d.source_type SourceType
2048: FROM ar_cash_receipt_history crh,
2049: ar_cash_receipts cr,
2050: ar_distributions d
2051: WHERE crh.gl_date BETWEEN p_Post.GlDateFrom
2052: AND p_Post.GlDateTo

Line 2089: -- ar_cash_receipt_history crh,

2085: -- cr.doc_sequence_value DocSequenceValue,
2086: -- cr.ussgl_transaction_code UssglTransactionCode,
2087: -- d.source_type SourceType
2088: -- FROM ar_mc_cash_receipt_hist crh_mc,
2089: -- ar_cash_receipt_history crh,
2090: -- ar_cash_receipts cr,
2091: -- ar_distributions_mrc_v d
2092: -- WHERE crh.gl_date BETWEEN p_Post.GlDateFrom
2093: -- AND p_Post.GlDateTo

Line 2160: l_gl_interface.reference30 := 'AR_CASH_RECEIPT_HISTORY' ;

2156: l_gl_interface.reference24 := RCrh.ReceiptNumber;
2157: l_gl_interface.reference27 := RCrh.PayFromCustomer;
2158: l_gl_interface.reference28 := RCrh.ModifiedType;
2159: l_gl_interface.reference29 := RCrh.ModifiedType||'_'||RCrh.SourceType;
2160: l_gl_interface.reference30 := 'AR_CASH_RECEIPT_HISTORY' ;
2161:
2162: CreateInterface( l_gl_interface );
2163:
2164: EXCEPTION

Line 2174: arp_standard.debug( ' AR_CASH_RECEIPT_HISTORY...' );

2170: -- This is the actual PostCashReceiptHistory body
2171: --
2172: BEGIN
2173: arp_standard.debug( ' ' );
2174: arp_standard.debug( ' AR_CASH_RECEIPT_HISTORY...' );
2175:
2176: -- bug3769452 modified IF condition
2177: IF (p_Post.SetOfBooksType <> 'R')
2178: THEN

Line 2186: UPDATE ar_cash_receipt_history

2182: FETCH CCrh
2183: INTO RCrh;
2184: EXIT WHEN CCrh%NOTFOUND;
2185: InsertIntoGl( RCrh );
2186: UPDATE ar_cash_receipt_history
2187: SET posting_control_id = p_Post.PostingControlId,
2188: gl_posted_date = p_Post.GlPostedDate
2189: WHERE ROWID = RCrh.CrhRowid;
2190: l_Count := l_Count + 1;

Line 2488: UPDATE ar_cash_receipt_history

2484:
2485: -- bug3769452 modified IF condition
2486: IF (p_Post.SetOfBooksType <> 'R')
2487: THEN
2488: UPDATE ar_cash_receipt_history
2489: SET gl_posted_date = NULL,
2490: posting_control_id = p_Post.UnpostedPostingControlId
2491: WHERE posting_control_id = p_Post.PostingControlId
2492: AND cash_receipt_id = p_BalanceId;

Line 2494: UPDATE ar_cash_receipt_history

2490: posting_control_id = p_Post.UnpostedPostingControlId
2491: WHERE posting_control_id = p_Post.PostingControlId
2492: AND cash_receipt_id = p_BalanceId;
2493:
2494: UPDATE ar_cash_receipt_history
2495: SET reversal_gl_posted_date = NULL,
2496: reversal_posting_control_id = p_Post.UnpostedPostingControlId
2497: WHERE reversal_posting_control_id = p_Post.PostingControlId
2498: AND cash_receipt_id = p_BalanceId;