[Home] [Help]
4046: p_cr_payment_schedule_id,
4047: p_remittance_bank_account_id,
4048: p_receipt_method_id
4049: FROM ar_cash_receipts cr,
4050: ar_cash_receipt_history crh,
4051: ar_payment_schedules ps,
4052: ce_bank_acct_uses ba
4053: WHERE cr.remit_bank_acct_use_id = ba.bank_acct_use_id and
4054: cr.cash_receipt_id = crh.cash_receipt_id and
4081: p_cr_payment_schedule_id,
4082: p_remittance_bank_account_id,
4083: p_receipt_method_id
4084: FROM ar_cash_receipts cr,
4085: ar_cash_receipt_history crh,
4086: ar_payment_schedules ps,
4087: ce_bank_acct_uses ba
4088: WHERE cr.remit_bank_acct_use_id = ba.bank_acct_use_id and
4089: cr.cash_receipt_id = crh.cash_receipt_id and
5635: THEN
5636: BEGIN
5637: SELECT gl_date
5638: INTO p_receipt_gl_date
5639: FROM ar_cash_receipt_history crh
5640: WHERE crh.cash_receipt_id = l_cash_receipt_id
5641: and crh.FIRST_POSTED_RECORD_FLAG = 'Y';
5642: -- Bug 3074658, Inconsistent bahaviour between UI/API
5643: -- AND crh.current_record_flag = 'Y';
5829:
5830: SELECT cr.receipt_date, crh.status, cr.type
5831: INTO l_receipt_date, p_receipt_state, p_type
5832: FROM ar_cash_receipts cr,
5833: ar_cash_receipt_history crh
5834: WHERE cr.cash_receipt_id = crh.cash_receipt_id
5835: AND crh.current_record_flag = 'Y'
5836: AND cr.cash_receipt_id = p_cash_receipt_id;
5837:
5839: p_receipt_gl_date should be populated as the max(gl_date) from CRH */
5840:
5841: SELECT max(crh.gl_date)
5842: INTO p_receipt_gl_date
5843: FROM ar_cash_receipt_history crh
5844: WHERE crh.cash_receipt_id = p_cash_receipt_id;
5845:
5846: /*Default reversal_date */
5847: IF p_reversal_date IS NULL THEN
6238: THEN
6239: BEGIN
6240: SELECT gl_date
6241: INTO p_receipt_gl_date
6242: FROM ar_cash_receipt_history crh
6243: WHERE crh.cash_receipt_id = l_cash_receipt_id
6244: and crh.current_record_flag = 'Y';
6245: EXCEPTION
6246: WHEN no_data_found THEN