Line 1747: SELECT lookup_code, description from cs_lookups
1743: p_lookup_code IN VARCHAR2
1744: ) return varchar2
1745: AS
1746: Cursor l_sr_dup_mesg_csr is 1747: SELECT lookup_code, description from cs_lookups 1748: WHERE lookup_type = 'CS_SR_DUPLICATE_REASON_CODE'
1749: and lookup_code = p_lookup_code;
1750: l_sr_dup_mesg_rec l_sr_dup_mesg_csr%ROWTYPE;
1751: BEGIN