APPS.OKC_TGN_PVT dependencies on OKC_CONDITION_HEADERS_B

Line 584: FROM okc_condition_headers_b, okc_k_headers_b k

580: CURSOR okc_cnhv_pk_csr (p_id IN NUMBER,
581: p_dnz_chr_id IN NUMBER) IS
582: SELECT
583: '1'
584: FROM okc_condition_headers_b, okc_k_headers_b k
585: WHERE okc_condition_headers_b.id = p_id
586: AND okc_condition_headers_b.dnz_chr_id = p_dnz_chr_id and
587: okc_condition_headers_b.template_yn = k.template_yn and
588: okc_condition_headers_b.dnz_chr_id = k.id;

Line 585: WHERE okc_condition_headers_b.id = p_id

581: p_dnz_chr_id IN NUMBER) IS
582: SELECT
583: '1'
584: FROM okc_condition_headers_b, okc_k_headers_b k
585: WHERE okc_condition_headers_b.id = p_id
586: AND okc_condition_headers_b.dnz_chr_id = p_dnz_chr_id and
587: okc_condition_headers_b.template_yn = k.template_yn and
588: okc_condition_headers_b.dnz_chr_id = k.id;
589: CURSOR okc_cnhv_pk_csr1 (p_id IN NUMBER) IS

Line 586: AND okc_condition_headers_b.dnz_chr_id = p_dnz_chr_id and

582: SELECT
583: '1'
584: FROM okc_condition_headers_b, okc_k_headers_b k
585: WHERE okc_condition_headers_b.id = p_id
586: AND okc_condition_headers_b.dnz_chr_id = p_dnz_chr_id and
587: okc_condition_headers_b.template_yn = k.template_yn and
588: okc_condition_headers_b.dnz_chr_id = k.id;
589: CURSOR okc_cnhv_pk_csr1 (p_id IN NUMBER) IS
590: SELECT

Line 587: okc_condition_headers_b.template_yn = k.template_yn and

583: '1'
584: FROM okc_condition_headers_b, okc_k_headers_b k
585: WHERE okc_condition_headers_b.id = p_id
586: AND okc_condition_headers_b.dnz_chr_id = p_dnz_chr_id and
587: okc_condition_headers_b.template_yn = k.template_yn and
588: okc_condition_headers_b.dnz_chr_id = k.id;
589: CURSOR okc_cnhv_pk_csr1 (p_id IN NUMBER) IS
590: SELECT
591: '1'

Line 588: okc_condition_headers_b.dnz_chr_id = k.id;

584: FROM okc_condition_headers_b, okc_k_headers_b k
585: WHERE okc_condition_headers_b.id = p_id
586: AND okc_condition_headers_b.dnz_chr_id = p_dnz_chr_id and
587: okc_condition_headers_b.template_yn = k.template_yn and
588: okc_condition_headers_b.dnz_chr_id = k.id;
589: CURSOR okc_cnhv_pk_csr1 (p_id IN NUMBER) IS
590: SELECT
591: '1'
592: FROM okc_condition_headers_b

Line 592: FROM okc_condition_headers_b

588: okc_condition_headers_b.dnz_chr_id = k.id;
589: CURSOR okc_cnhv_pk_csr1 (p_id IN NUMBER) IS
590: SELECT
591: '1'
592: FROM okc_condition_headers_b
593: WHERE okc_condition_headers_b.id = p_id
594: AND okc_condition_headers_b.dnz_chr_id is NULL and
595: okc_condition_headers_b.template_yn = 'Y';
596: l_okc_cnhv_pk okc_cnhv_pk_csr%ROWTYPE;

Line 593: WHERE okc_condition_headers_b.id = p_id

589: CURSOR okc_cnhv_pk_csr1 (p_id IN NUMBER) IS
590: SELECT
591: '1'
592: FROM okc_condition_headers_b
593: WHERE okc_condition_headers_b.id = p_id
594: AND okc_condition_headers_b.dnz_chr_id is NULL and
595: okc_condition_headers_b.template_yn = 'Y';
596: l_okc_cnhv_pk okc_cnhv_pk_csr%ROWTYPE;
597: l_okc_cnhv_pk1 okc_cnhv_pk_csr1%ROWTYPE;

Line 594: AND okc_condition_headers_b.dnz_chr_id is NULL and

590: SELECT
591: '1'
592: FROM okc_condition_headers_b
593: WHERE okc_condition_headers_b.id = p_id
594: AND okc_condition_headers_b.dnz_chr_id is NULL and
595: okc_condition_headers_b.template_yn = 'Y';
596: l_okc_cnhv_pk okc_cnhv_pk_csr%ROWTYPE;
597: l_okc_cnhv_pk1 okc_cnhv_pk_csr1%ROWTYPE;
598: BEGIN

Line 595: okc_condition_headers_b.template_yn = 'Y';

591: '1'
592: FROM okc_condition_headers_b
593: WHERE okc_condition_headers_b.id = p_id
594: AND okc_condition_headers_b.dnz_chr_id is NULL and
595: okc_condition_headers_b.template_yn = 'Y';
596: l_okc_cnhv_pk okc_cnhv_pk_csr%ROWTYPE;
597: l_okc_cnhv_pk1 okc_cnhv_pk_csr1%ROWTYPE;
598: BEGIN
599: x_return_status := OKC_API.G_RET_STS_SUCCESS;