APPS.OKC_RGP_PVT dependencies on OKC_SUBCLASS_RG_DEFS

Line 41: FROM OKC_SUBCLASS_RG_DEFS srdv,

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,
43: OKC_K_HEADERS_B chrv
44: WHERE srdv.SCS_CODE = scsv.CODE
45: AND scsv.CODE = chrv.SCS_CODE

Line 69: okc_subclass_rg_defs srd

65: AND id <> NVL(p_rgpv_rec.id,-1);
66:
67: CURSOR csr_rg_subject_object (p_scs_code IN VARCHAR2, p_rgd_code IN VARCHAR2) IS
68: select 'x' from okc_rg_role_defs rrd,
69: okc_subclass_rg_defs srd
70: where srd_id = srd.id
71: and scs_code = p_scs_code
72: and rgd_code = p_rgd_code
73: and rownum < 2;