38: FROM FND_LOOKUP_VALUES rgdv
39: WHERE (p_rgpv_rec.rgd_code IN
40: (SELECT srdv.RGD_CODE
41: FROM OKC_SUBCLASS_RG_DEFS srdv, 42: OKC_SUBCLASSES_B scsv, 43: OKC_K_HEADERS_B chrv
44: WHERE srdv.SCS_CODE = scsv.CODE
45: AND scsv.CODE = chrv.SCS_CODE
46: AND chrv.ID = p_rgpv_rec.dnz_chr_id) OR