[Home] [Help]
28: CURSOR CRa IS
29: SELECT DISTINCT
30: ra.receivable_application_id
31: FROM ar_receivable_applications ra,
32: ar_cash_receipts cr
33: WHERE ra.gl_date >= p_Prepare.GlDateFrom
34: AND ra.gl_date <= p_Prepare.GlDateTo
35: AND nvl(ra.postable,'Y') = 'Y'
36: AND nvl(ra.confirmed_flag,'Y') = 'Y'
115: ra.receivable_application_id
116: FROM ar_receivable_applications ra,
117: ra_cust_trx_types ctt,
118: ra_customer_trx ct,
119: ar_cash_receipts cr,
120: ar_cash_receipt_history crh,
121: ra_customer_trx ctcm,
122: ar_lookups l
123: WHERE ra.gl_date BETWEEN p_Prepare.GlDateFrom
208: PROCEDURE PostCashReceiptHistory( p_Prepare IN ParametersType ) IS
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'
290: PROCEDURE PostRevCashReceiptHist( p_Prepare IN ParametersType ) IS
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'
378: PROCEDURE PostMiscCashDistributions( p_Prepare IN ParametersType ) IS
379: CURSOR CMcd IS
380: SELECT distinct mcd.misc_cash_distribution_id
381: FROM ar_misc_cash_distributions mcd,
382: ar_cash_receipts cr
383: WHERE mcd.gl_date BETWEEN p_Prepare.GlDateFrom
384: AND p_Prepare.GlDateTo
385: AND mcd.set_of_books_id = p_Prepare.setofbooksid
386: AND cr.cash_receipt_id = mcd.cash_receipt_id ;