656: ) RETURN VARCHAR2 IS
657: item_not_found_error EXCEPTION;
658: CURSOR okc_srev_pk_csr (p_id IN NUMBER) IS
659: SELECT 'x'
660: FROM Okc_Subclass_Roles_V
661: WHERE okc_subclass_roles_v.id = p_id;
662: CURSOR okc_srdv_pk_csr (p_id IN NUMBER) IS
663: SELECT 'x'
664: FROM Okc_Subclass_Rg_Defs_V
657: item_not_found_error EXCEPTION;
658: CURSOR okc_srev_pk_csr (p_id IN NUMBER) IS
659: SELECT 'x'
660: FROM Okc_Subclass_Roles_V
661: WHERE okc_subclass_roles_v.id = p_id;
662: CURSOR okc_srdv_pk_csr (p_id IN NUMBER) IS
663: SELECT 'x'
664: FROM Okc_Subclass_Rg_Defs_V
665: WHERE okc_subclass_rg_defs_v.id = p_id;