APPS.OKC_RMP_PVT dependencies on OKC_K_HEADERS_B

Line 43: , okc_k_headers_b KHD

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
46: and KHD.id = p_rmpv_rec.dnz_chr_id
47: and SRD.SCS_CODE = KHD.SCS_CODE)

Line 131: OKC_K_HEADERS_B chrv

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)
135: AND rrdv.ID = p_rmpv_rec.RRD_ID;

Line 219: OKC_K_HEADERS_B chrv

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)
223: AND cplv.ID = p_rmpv_rec.CPL_ID;

Line 232: , okc_k_headers_b KHD

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
236: and SRE.SCS_CODE = KHD.SCS_CODE)

Line 306: FROM OKC_K_HEADERS_B chrv

302: ) IS
303: l_dummy_var VARCHAR2(1) := '?';
304: CURSOR l_chrv_csr IS
305: SELECT 'x'
306: FROM OKC_K_HEADERS_B chrv
307: WHERE chrv.ID = p_rmpv_rec.DNZ_CHR_ID;
308: BEGIN
309: -- initialize return status
310: x_return_status := OKC_API.G_RET_STS_SUCCESS;