APPS.IGIRCBAP dependencies on AR_CASH_RECEIPT_HISTORY

Line 1392: ar_cash_receipt_history crh,

1388: igi_ar_rec_applications igira,
1389: ra_cust_trx_types ctt,
1390: ra_customer_trx ct,
1391: ar_cash_receipts cr,
1392: ar_cash_receipt_history crh,
1393: ra_customer_trx ctcm,
1394: ar_lookups l
1395: WHERE igira.arc_posting_control_id = p_Post.UnpostedPostingControlId
1396: AND igira.receivable_application_id = ra.receivable_application_id

Line 1574: FROM ar_cash_receipt_history crh,

1570: cr.doc_sequence_id DocSequenceId,
1571: cr.doc_sequence_value DocSequenceValue,
1572: cr.ussgl_transaction_code UssglTransactionCode,
1573: d.source_type SourceType
1574: FROM ar_cash_receipt_history crh,
1575: igi_ar_cash_receipt_hist igicrh,
1576: ar_cash_receipts cr,
1577: ar_distributions d
1578: WHERE trunc(crh.gl_date) >= p_Post.GlDateFrom

Line 1679: 'AR_CASH_RECEIPT_HISTORY' -- reference30

1675: RCrh.ReceiptNumber, -- reference24
1676: RCrh.PayFromCustomer, -- reference27
1677: RCrh.ModifiedType, -- reference28
1678: RCrh.ModifiedType||'_'||RCrh.SourceType, -- reference29
1679: 'AR_CASH_RECEIPT_HISTORY' -- reference30
1680: );
1681: if sql%found then
1682: WriteToLog ( l_state_level, 'InsertIntoGL','Insert into GL interface okay!');
1683: end if;

Line 1694: WritetoLog( l_state_level, 'PostCashReceiptHistory',' AR_CASH_RECEIPT_HISTORY...' );

1690: -- This is the actual PostCashReceiptHistory body
1691: --
1692: BEGIN
1693: WritetoLog( l_state_level, 'PostCashReceiptHistory',' ' );
1694: WritetoLog( l_state_level, 'PostCashReceiptHistory',' AR_CASH_RECEIPT_HISTORY...' );
1695: OPEN CCrh;
1696: LOOP
1697: FETCH CCrh
1698: INTO RCrh;

Line 1907: from ar_cash_receipt_history acrh

1903: arc_posting_control_id = p_Post.UnpostedPostingControlId
1904: WHERE arc_posting_control_id = p_Post.PostingControlId
1905: AND EXISTS
1906: ( select cash_receipt_id
1907: from ar_cash_receipt_history acrh
1908: where acrh.cash_receipt_id = p_BalanceId
1909: and acrh.cash_receipt_history_id = iacrh.cash_receipt_history_id
1910: );
1911: --

Line 1918: from ar_cash_receipt_history acrh

1914: arc_rev_post_control_id = p_Post.UnpostedPostingControlId
1915: WHERE arc_rev_post_control_id = p_Post.PostingControlId
1916: AND EXISTS
1917: ( select cash_receipt_id
1918: from ar_cash_receipt_history acrh
1919: where acrh.cash_receipt_id = p_BalanceId
1920: and acrh.cash_receipt_history_id = iacrh.cash_receipt_history_id
1921: );
1922: END IF;

Line 2322: FROM ar_cash_receipt_history crh

2318: ***/
2319: /***
2320: SELECT nvl(max(crh.cash_receipt_history_id), 999999999999998)+1
2321: INTO l_Post.NxtCashReceiptHistoryId
2322: FROM ar_cash_receipt_history crh
2323: , igi_ar_cash_receipt_hist igicrh
2324: WHERE crh.cash_receipt_history_id = igicrh.cash_receipt_history_id
2325: AND igicrh.arc_posting_control_id = p_PostingControlId;
2326: