DBA Data[Home] [Help]

APPS.OKC_RMP_PVT dependencies on OKC_SUBCLASS_ROLES

Line 129: FROM OKC_SUBCLASS_ROLES srev,

125: SELECT 'x'
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

Line 217: FROM OKC_SUBCLASS_ROLES_B srev,

213: /* SELECT 'x'
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

Line 231: , okc_subclass_roles SRE

227: where CPL.id = p_rmpv_rec.cpl_id
228: and CPL.rle_code in (
229: select SRE.rle_code
230: from okc_rg_role_defs RRD
231: , okc_subclass_roles SRE
232: , okc_k_headers_b KHD
233: where RRD.id = p_rmpv_rec.rrd_id
234: and SRE.id = RRD.sre_id
235: and KHD.id = p_rmpv_rec.dnz_chr_id