APPS.OKC_RGP_PVT dependencies on OKC_K_HEADERS_B

Line 43: OKC_K_HEADERS_B chrv

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
46: AND chrv.ID = p_rgpv_rec.dnz_chr_id) OR
47: (p_rgpv_rec.rgp_type = 'SRG'))

Line 491: FROM OKC_K_HEADERS_B chrv

487: ) IS
488: l_dummy_var VARCHAR2(1) := '?';
489: CURSOR l_chrv_csr IS
490: SELECT 'x'
491: FROM OKC_K_HEADERS_B chrv
492: WHERE chrv.ID = p_rgpv_rec.CHR_ID;
493: BEGIN
494: -- initialize return status
495: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 666: FROM OKC_K_HEADERS_B chrv

662: ) IS
663: l_scs_code VARCHAR2(30) := NULL;
664: CURSOR l_chrv_csr IS
665: SELECT scs_code
666: FROM OKC_K_HEADERS_B chrv
667: WHERE chrv.ID = p_rgpv_rec.DNZ_CHR_ID;
668: BEGIN
669: -- initialize return status
670: x_return_status := OKC_API.G_RET_STS_SUCCESS;