Line 1809: SELECT lookup_code, description from cs_lookups
1805: p_lookup_code IN VARCHAR2
1806: ) return varchar2
1807: AS
1808: Cursor l_sr_dup_mesg_csr is 1809: SELECT lookup_code, description from cs_lookups 1810: WHERE lookup_type = 'CS_SR_DUPLICATE_REASON_CODE'
1811: and lookup_code = p_lookup_code;
1812: l_sr_dup_mesg_rec l_sr_dup_mesg_csr%ROWTYPE;
1813: BEGIN