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;
666: l_dummy VARCHAR2(1);
667: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
668: l_row_notfound BOOLEAN := TRUE;
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;
666: l_dummy VARCHAR2(1);
667: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
668: l_row_notfound BOOLEAN := TRUE;
669: BEGIN