1660: p_new_state_dsp
1661: FROM
1662: ar_cash_receipt_history crh_current,
1663: ar_cash_receipts cr,
1664: ar_lookups l_cr_status,
1665: ar_lookups l_crh_status
1666: WHERE
1667: cr.cash_receipt_id = p_cash_receipt_id
1668: AND l_cr_status.lookup_type = 'CHECK_STATUS'
1661: FROM
1662: ar_cash_receipt_history crh_current,
1663: ar_cash_receipts cr,
1664: ar_lookups l_cr_status,
1665: ar_lookups l_crh_status
1666: WHERE
1667: cr.cash_receipt_id = p_cash_receipt_id
1668: AND l_cr_status.lookup_type = 'CHECK_STATUS'
1669: AND l_cr_status.lookup_code = cr.status