DBA Data[Home] [Help]

APPS.IGIRCBID dependencies on AR_DISTRIBUTIONS

Line 213: ar_distributions d

209: CURSOR CCrh IS
210: SELECT distinct crh.cash_receipt_history_id
211: FROM ar_cash_receipt_history crh,
212: ar_cash_receipts cr,
213: ar_distributions d
214: WHERE crh.gl_date BETWEEN p_Prepare.GlDateFrom
215: AND p_Prepare.GlDateTo
216: AND crh.postable_flag = 'Y'
217: AND cr.cash_receipt_id = crh.cash_receipt_id

Line 295: ar_distributions d

291: CURSOR CCrh IS
292: SELECT distinct crh.cash_receipt_history_id
293: FROM ar_cash_receipt_history crh,
294: ar_cash_receipts cr,
295: ar_distributions d
296: WHERE crh.reversal_gl_date BETWEEN p_Prepare.GlDateFrom
297: AND p_Prepare.GlDateTo
298: AND crh.postable_flag = 'Y'
299: AND cr.cash_receipt_id = crh.cash_receipt_id