APPS.ARP_PROCESS_MISC_RECEIPTS dependencies on AR_MISC_CASH_DISTRIBUTIONS

Line 63: | is on ar_misc_cash_distributions not |

59: | 26-SEP-02 RKADER Bug #2561342: The GL date should not be |
60: | updated for the history record while a Misc |
61: | receipt is updated
62: | 14-OCT-04 JBECKETT Bug 3911642: Check for unposted entries |
63: | is on ar_misc_cash_distributions not |
64: | ar_cash_receipt_history as rows from the |
65: | former are deleted/recreated. |
66: | 20-MAY-05 JBECKETT Added p_legal_entity_id for R12 LE uptake |
67: +===========================================================================*/

Line 450: ar_misc_cash_distributions as it is this accounting that is deleted/

446: p_gl_tax_acct);
447:
448: -- Check if Misc Receipt has been posted before calling accounting entry library
449: /* Bug 3911642 - check for unposted rows should be in
450: ar_misc_cash_distributions as it is this accounting that is deleted/
451: recreated. */
452: SELECT count(*)
453: INTO l_unposted_count
454: FROM ar_misc_cash_distributions

Line 454: FROM ar_misc_cash_distributions

450: ar_misc_cash_distributions as it is this accounting that is deleted/
451: recreated. */
452: SELECT count(*)
453: INTO l_unposted_count
454: FROM ar_misc_cash_distributions
455: WHERE cash_receipt_id = p_cash_receipt_id
456: AND posting_control_id = -3
457: AND reversal_gl_date IS NULL;
458: