DBA Data[Home] [Help]

APPS.AR_RECEIPT_LIB_PVT dependencies on AR_CASH_RECEIPT_HISTORY

Line 4279: ar_cash_receipt_history crh,

4275: p_cr_payment_schedule_id,
4276: p_remittance_bank_account_id,
4277: p_receipt_method_id
4278: FROM ar_cash_receipts cr,
4279: ar_cash_receipt_history crh,
4280: ar_payment_schedules ps,
4281: ce_bank_acct_uses ba
4282: WHERE cr.remit_bank_acct_use_id = ba.bank_acct_use_id and
4283: cr.cash_receipt_id = crh.cash_receipt_id and

Line 4314: ar_cash_receipt_history crh,

4310: p_cr_payment_schedule_id,
4311: p_remittance_bank_account_id,
4312: p_receipt_method_id
4313: FROM ar_cash_receipts cr,
4314: ar_cash_receipt_history crh,
4315: ar_payment_schedules ps,
4316: ce_bank_acct_uses ba
4317: WHERE cr.remit_bank_acct_use_id = ba.bank_acct_use_id and
4318: cr.cash_receipt_id = crh.cash_receipt_id and

Line 5909: FROM ar_cash_receipt_history crh

5905: THEN
5906: BEGIN
5907: SELECT gl_date
5908: INTO p_receipt_gl_date
5909: FROM ar_cash_receipt_history crh
5910: WHERE crh.cash_receipt_id = l_cash_receipt_id
5911: and crh.FIRST_POSTED_RECORD_FLAG = 'Y';
5912: -- Bug 3074658, Inconsistent bahaviour between UI/API
5913: -- AND crh.current_record_flag = 'Y';

Line 6105: ar_cash_receipt_history crh

6101:
6102: SELECT cr.receipt_date, crh.status, cr.type
6103: INTO l_receipt_date, p_receipt_state, p_type
6104: FROM ar_cash_receipts cr,
6105: ar_cash_receipt_history crh
6106: WHERE cr.cash_receipt_id = crh.cash_receipt_id
6107: AND crh.current_record_flag = 'Y'
6108: AND cr.cash_receipt_id = p_cash_receipt_id;
6109:

Line 6115: FROM ar_cash_receipt_history crh

6111: p_receipt_gl_date should be populated as the max(gl_date) from CRH */
6112:
6113: SELECT max(crh.gl_date)
6114: INTO p_receipt_gl_date
6115: FROM ar_cash_receipt_history crh
6116: WHERE crh.cash_receipt_id = p_cash_receipt_id;
6117:
6118: /* Bug 8668394 : Default Reversal Date and Reversal Gl Date correctly */
6119: BEGIN

Line 6530: FROM ar_cash_receipt_history crh

6526: THEN
6527: BEGIN
6528: SELECT gl_date
6529: INTO p_receipt_gl_date
6530: FROM ar_cash_receipt_history crh
6531: WHERE crh.cash_receipt_id = l_cash_receipt_id
6532: and crh.current_record_flag = 'Y';
6533: EXCEPTION
6534: WHEN no_data_found THEN