APPS.OKC_REPORT_PVT dependencies on OKC_K_VERS_NUMBERS_V

Line 352: okc_k_vers_numbers_v V

348: x_minor_version out nocopy number) is
349: cursor k_version_csr(pp_chr_id number,pp_major_version number) is
350: select V.MAJOR_VERSION, V.MINOR_VERSION
351: from
352: okc_k_vers_numbers_v V
353: where V.CHR_ID = pp_chr_id
354: and (pp_major_version is NULL or pp_major_version = V.MAJOR_VERSION)
355: union all
356: select pp_major_version, max(H.MINOR_VERSION) MINOR_VERSION

Line 357: from okc_k_vers_numbers_v V1,

353: where V.CHR_ID = pp_chr_id
354: and (pp_major_version is NULL or pp_major_version = V.MAJOR_VERSION)
355: union all
356: select pp_major_version, max(H.MINOR_VERSION) MINOR_VERSION
357: from okc_k_vers_numbers_v V1,
358: OKC_K_VERS_NUMBERS_H H
359: where V1.CHR_ID = pp_chr_id
360: and H.CHR_ID = pp_chr_id
361: and H.MAJOR_VERSION = pp_major_version

Line 2257: from OKC_K_VERS_NUMBERS_V

2253: v number := p_major_version;
2254: cursor c1(k number) is
2255: select
2256: MAJOR_VERSION
2257: from OKC_K_VERS_NUMBERS_V
2258: where CHR_ID = k;
2259: begin
2260: errbuf := '';
2261: retcode := '0';