APPS.IGIRCBAP dependencies on IGI_AR_CASH_RECEIPT_HIST

Line 1575: igi_ar_cash_receipt_hist igicrh,

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
1579: AND trunc(crh.gl_date) <= p_Post.GlDateTo

Line 1701: UPDATE igi_ar_cash_receipt_hist

1697: FETCH CCrh
1698: INTO RCrh;
1699: EXIT WHEN CCrh%NOTFOUND;
1700: InsertIntoGl( RCrh );
1701: UPDATE igi_ar_cash_receipt_hist
1702: SET arc_posting_control_id = p_Post.PostingControlId,
1703: arc_gl_posted_date = p_Post.GlPostedDate
1704: WHERE ROWID = RCrh.IGICrhRowid;
1705: l_Count := l_Count + 1;

Line 1901: UPDATE igi_ar_cash_receipt_hist iacrh

1897: IF ( p_CategoryCode = 'TRADE') OR
1898: (p_CategoryCode = 'CROSS CURR') OR
1899: ( p_CategoryCode = 'MISC' )
1900: THEN
1901: UPDATE igi_ar_cash_receipt_hist iacrh
1902: SET arc_gl_posted_date = NULL,
1903: arc_posting_control_id = p_Post.UnpostedPostingControlId
1904: WHERE arc_posting_control_id = p_Post.PostingControlId
1905: AND EXISTS

Line 1912: UPDATE igi_ar_cash_receipt_hist iacrh

1908: where acrh.cash_receipt_id = p_BalanceId
1909: and acrh.cash_receipt_history_id = iacrh.cash_receipt_history_id
1910: );
1911: --
1912: UPDATE igi_ar_cash_receipt_hist iacrh
1913: SET arc_rev_gl_posted_date = NULL,
1914: arc_rev_post_control_id = p_Post.UnpostedPostingControlId
1915: WHERE arc_rev_post_control_id = p_Post.PostingControlId
1916: AND EXISTS

Line 2323: , igi_ar_cash_receipt_hist igicrh

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:
2327: SELECT nvl(max(app.receivable_application_id), 999999999999998)+1