APPS.OKC_RGP_PVT dependencies on FND_LOOKUP_VALUES

Line 38: FROM FND_LOOKUP_VALUES rgdv

34: -- Bug 1367397: changed subclass views in cursor to base table
35:
36: CURSOR l_rgdv_csr IS
37: SELECT 'x'
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,

Line 212: FROM FND_LOOKUP_VALUES satv

208: ) IS
209: l_dummy_var VARCHAR2(1) := '?';
210: CURSOR l_satv_csr IS
211: SELECT 'x'
212: FROM FND_LOOKUP_VALUES satv
213: WHERE satv.LOOKUP_CODE = p_rgpv_rec.sat_code
214: AND satv.lookup_type = 'OKC_ARTICLE_SET';
215: BEGIN
216: -- initialize return status