APPS.OKL_COPY_CONTRACT_PVT dependencies on OKC_RULE_GROUPS_V

Line 2230: FROM okc_rule_groups_v

2226:
2227: CURSOR del_rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2228: p_rgp_id NUMBER) IS
2229: SELECT id
2230: FROM okc_rule_groups_v
2231: WHERE dnz_chr_id = p_chr_id
2232: AND id = p_rgp_id
2233: AND rgd_code = 'LALEVL';
2234:

Line 2398: FROM okc_rule_groups_v

2394: CURSOR lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2395: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2396: SELECT id,
2397: cle_id
2398: FROM okc_rule_groups_v
2399: WHERE dnz_chr_id = p_chr_id
2400: AND cle_id = p_cle_id
2401: AND rgd_code = 'LALEVL';
2402:

Line 2406: FROM okc_rule_groups_v

2402:
2403: CURSOR old_lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2404: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2405: SELECT id
2406: FROM okc_rule_groups_v
2407: WHERE dnz_chr_id = p_chr_id
2408: AND rgd_code = 'LALEVL'
2409: AND (cle_id = p_cle_id
2410: OR ( cle_id IS NULL

Line 2485: FROM okc_rule_groups_v

2481:
2482: CURSOR lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
2483: SELECT id,
2484: cle_id
2485: FROM okc_rule_groups_v
2486: WHERE dnz_chr_id = p_chr_id
2487: AND cle_id IS NULL -- Bug 2376998
2488: AND rgd_code = 'LALEVL';
2489:

Line 2493: FROM okc_rule_groups_v

2489:
2490: CURSOR old_lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2491: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2492: SELECT id
2493: FROM okc_rule_groups_v
2494: WHERE dnz_chr_id = p_chr_id
2495: AND rgd_code = 'LALEVL'
2496: AND (cle_id = p_cle_id
2497: OR ( cle_id IS NULL