DBA Data[Home] [Help]

APPS.OKC_RMP_PVT dependencies on OKC_RG_ROLE_DEFS

Line 41: from okc_rg_role_defs RRD

37: from okc_rule_groups_b RGP
38: where RGP.id = p_rmpv_rec.rgp_id
39: and RGP.rgd_code in (
40: select SRD.rgd_code
41: from okc_rg_role_defs RRD
42: , okc_subclass_rg_defs SRD
43: , okc_k_headers_b KHD
44: where RRD.id = p_rmpv_rec.rrd_id
45: and SRD.id = RRD.srd_id

Line 126: FROM OKC_RG_ROLE_DEFS rrdv

122: ) IS
123: l_dummy_var VARCHAR2(1) := '?';
124: CURSOR l_rrdv_csr IS
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,

Line 230: from okc_rg_role_defs RRD

226: from okc_k_party_roles_b CPL
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