1817: p_new_state_dsp
1818: FROM
1819: ar_cash_receipt_history crh_current,
1820: ar_cash_receipts cr,
1821: ar_lookups l_cr_status,
1822: ar_lookups l_crh_status
1823: WHERE
1824: cr.cash_receipt_id = p_cash_receipt_id
1825: AND l_cr_status.lookup_type = 'CHECK_STATUS'
1818: FROM
1819: ar_cash_receipt_history crh_current,
1820: ar_cash_receipts cr,
1821: ar_lookups l_cr_status,
1822: ar_lookups l_crh_status
1823: WHERE
1824: cr.cash_receipt_id = p_cash_receipt_id
1825: AND l_cr_status.lookup_type = 'CHECK_STATUS'
1826: AND l_cr_status.lookup_code = cr.status