APPS.AR_BUS_EVENT_SUB_PVT dependencies on AR_CASH_RECEIPT_HISTORY

Line 3642: from ar_cash_receipt_history

3638: WHERE payment_schedule_id = p_ps_id;
3639:
3640: CURSOR get_receipt_status (p_cr_id IN NUMBER)IS
3641: SELECT status
3642: from ar_cash_receipt_history
3643: where cash_receipt_history_id =
3644: (select min(cash_receipt_history_id)
3645: from ar_cash_receipt_history
3646: where cash_receipt_id = p_cr_id)

Line 3645: from ar_cash_receipt_history

3641: SELECT status
3642: from ar_cash_receipt_history
3643: where cash_receipt_history_id =
3644: (select min(cash_receipt_history_id)
3645: from ar_cash_receipt_history
3646: where cash_receipt_id = p_cr_id)
3647: ;
3648: l_receipt_status VARCHAR2(30);
3649: l_receipt_exists BOOLEAN := FALSE;

Line 3882: ar_cash_receipt_history crh,

3878: 'OTHER ACC',nvl(ra.amount_applied_from,ra.amount_applied),
3879: null)) unresolved_cash
3880: FROM ar_payment_schedules ps,
3881: ar_cash_receipts cr,
3882: ar_cash_receipt_history crh,
3883: ar_receivable_applications ra
3884: WHERE ps.payment_schedule_id = p_ps_id
3885: and ps.cash_receipt_id = cr.cash_receipt_id
3886: and crh.cash_receipt_id = cr.cash_receipt_id

Line 3920: ar_cash_receipt_history crh --apandit

3916: from ar_cash_receipts
3917: where cash_receipt_id =
3918: (select max(cr.cash_receipt_id)
3919: from ar_cash_receipts cr,
3920: ar_cash_receipt_history crh --apandit
3921: where cr.pay_from_customer = p_customer_id
3922: and cr.cash_receipt_id = crh.cash_receipt_id --apandit
3923: and crh.current_record_flag = 'Y'
3924: and crh.status <> 'REVERSED'

Line 4815: ar_cash_receipt_history crh

4811: FROM ar_cash_receipts
4812: WHERE cash_receipt_id =
4813: (SELECT MAX(cr.cash_receipt_id)
4814: FROM ar_cash_receipts cr,
4815: ar_cash_receipt_history crh
4816: WHERE cr.pay_from_customer = p_customer_id
4817: AND cr.cash_receipt_id = crh.cash_receipt_id
4818: AND crh.current_record_flag = 'Y'
4819: AND crh.status <> 'REVERSED'