APPS.IGIRCBAP dependencies on AR_MISC_CASH_DISTRIBUTIONS

Line 1721: | post unposted ar_misc_cash_distributions records |

1717: /*---------------------------------------------------------------------------*
1718: | PRIVATE PROCEDURE |
1719: | PostMiscCashDistributions |
1720: | DESCRIPTION |
1721: | post unposted ar_misc_cash_distributions records |
1722: | within the posting range |
1723: | |
1724: | PARAMETERS |
1725: | |

Line 1753: FROM ar_misc_cash_distributions mcd,

1749: p_Post.UserMisc category,
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

Line 1767: WritetoLog( l_state_level, 'PostMiscCashDistributions',' AR_MISC_CASH_DISTRIBUTIONS...' );

1763: --
1764: l_Count NUMBER :=0;
1765: BEGIN
1766: WritetoLog( l_state_level, 'PostMiscCashDistributions',' ' );
1767: WritetoLog( l_state_level, 'PostMiscCashDistributions',' AR_MISC_CASH_DISTRIBUTIONS...' );
1768: FOR RMcd IN CMcd
1769: LOOP
1770: -- first create the debit in gl_interface to the account_code_combination_id
1771: INSERT INTO gl_interface

Line 1854: 'AR_MISC_CASH_DISTRIBUTIONS' -- reference30

1850: RMcd.MiscCashDistributionId, -- reference23
1851: RMcd.ReceiptNumber, -- reference24
1852: 'MISC', -- reference28
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,

Line 1932: from ar_misc_cash_distributions amcd

1928: arc_posting_control_id = p_Post.UnpostedPostingControlId
1929: WHERE arc_posting_control_id = p_Post.PostingControlId
1930: AND EXISTS
1931: ( select cash_receipt_id
1932: from ar_misc_cash_distributions amcd
1933: where amcd.cash_receipt_id = p_BalanceId
1934: and amcd.misc_cash_distribution_id = amcd.misc_cash_distribution_id
1935: );
1936: END IF;

Line 2336: FROM ar_misc_cash_distributions mcd

2332: AND igiapp.arc_posting_control_id = p_PostingControlId;
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: