DBA Data[Home] [Help]

APPS.IGIRCBID dependencies on AR_CASH_RECEIPT_HISTORY

Line 120: ar_cash_receipt_history crh,

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
124: AND p_Prepare.GlDateTo

Line 211: FROM ar_cash_receipt_history crh,

207: END;
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

Line 293: FROM ar_cash_receipt_history crh,

289: --
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