595: p_new_state_dsp
596: FROM
597: ar_cash_receipt_history crh_current,
598: ar_cash_receipts cr,
599: ar_lookups l_cr_status,
600: ar_lookups l_crh_status
601: WHERE
602: cr.cash_receipt_id = p_cash_receipt_id
603: AND l_cr_status.lookup_type = 'CHECK_STATUS'
596: FROM
597: ar_cash_receipt_history crh_current,
598: ar_cash_receipts cr,
599: ar_lookups l_cr_status,
600: ar_lookups l_crh_status
601: WHERE
602: cr.cash_receipt_id = p_cash_receipt_id
603: AND l_cr_status.lookup_type = 'CHECK_STATUS'
604: AND l_cr_status.lookup_code = cr.status