DBA Data[Home] [Help]

APPS.OKC_RMP_PVT dependencies on OKC_SUBCLASSES_B

Line 130: OKC_SUBCLASSES_B scsv,

126: FROM OKC_RG_ROLE_DEFS rrdv
127: WHERE rrdv.SRE_ID IN
128: (SELECT srev.ID
129: FROM OKC_SUBCLASS_ROLES srev,
130: OKC_SUBCLASSES_B scsv,
131: OKC_K_HEADERS_B chrv
132: WHERE srev.SCS_CODE = scsv.CODE
133: AND scsv.CODE = chrv.SCS_CODE
134: AND chrv.ID = p_rmpv_rec.dnz_chr_id)

Line 218: OKC_SUBCLASSES_B scsv,

214: FROM OKC_K_PARTY_ROLES_V cplv
215: WHERE cplv.RLE_CODE IN
216: (SELECT srev.RLE_CODE
217: FROM OKC_SUBCLASS_ROLES_B srev,
218: OKC_SUBCLASSES_B scsv,
219: OKC_K_HEADERS_B chrv
220: WHERE srev.SCS_CODE = scsv.CODE
221: AND scsv.CODE = chrv.SCS_CODE
222: AND chrv.ID = p_rmpv_rec.dnz_chr_id)