APPS.IGIRCBAP dependencies on IGI_AR_MISC_CASH_DISTS

Line 1754: igi_ar_misc_cash_dists igimcd,

1750: cr.doc_sequence_id doc_sequence_id,
1751: cr.doc_sequence_value doc_sequence_value,
1752: mcd.ussgl_transaction_code ussgl_transaction_code
1753: FROM ar_misc_cash_distributions mcd,
1754: igi_ar_misc_cash_dists igimcd,
1755: ar_cash_receipts cr
1756: WHERE igimcd.arc_posting_control_id = p_Post.UnpostedPostingControlId
1757: AND trunc(mcd.gl_date) >= p_Post.GlDateFrom
1758: AND trunc(mcd.gl_date) <= p_Post.GlDateTo

Line 1857: UPDATE igi_ar_misc_cash_dists

1853: 'MISC_MISC', -- reference29
1854: 'AR_MISC_CASH_DISTRIBUTIONS' -- reference30
1855: );
1856: --
1857: UPDATE igi_ar_misc_cash_dists
1858: SET arc_posting_control_id = p_Post.PostingControlId,
1859: arc_gl_posted_date = p_Post.GlPostedDate
1860: WHERE ROWID = RMcd.IGIMcdRowid;
1861: l_Count := l_Count + 1;

Line 1926: UPDATE igi_ar_misc_cash_dists iamcd

1922: END IF;
1923: --
1924: IF p_CategoryCode = 'MISC'
1925: THEN
1926: UPDATE igi_ar_misc_cash_dists iamcd
1927: SET arc_gl_posted_date = NULL,
1928: arc_posting_control_id = p_Post.UnpostedPostingControlId
1929: WHERE arc_posting_control_id = p_Post.PostingControlId
1930: AND EXISTS

Line 2337: , igi_ar_misc_cash_dists igimcd

2333:
2334: SELECT nvl(max(mcd.misc_cash_distribution_id), 999999999999998)+1
2335: INTO l_Post.NxtMiscCashDistributionId
2336: FROM ar_misc_cash_distributions mcd
2337: , igi_ar_misc_cash_dists igimcd
2338: WHERE mcd.misc_cash_distribution_id = igimcd.misc_cash_distribution_id
2339: and igimcd.arc_posting_control_id = p_PostingControlId;
2340:
2341: SELECT nvl(max(adj.adjustment_id), 999999999999998)+1