APPS.OKL_COPY_CONTRACT_PVT dependencies on OKC_RULE_GROUPS_V

Line 2193: FROM okc_rule_groups_v

2189:
2190: CURSOR del_rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2191: p_rgp_id NUMBER) IS
2192: SELECT id
2193: FROM okc_rule_groups_v
2194: WHERE dnz_chr_id = p_chr_id
2195: AND id = p_rgp_id
2196: AND rgd_code = 'LALEVL';
2197:

Line 2361: FROM okc_rule_groups_v

2357: CURSOR lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2358: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2359: SELECT id,
2360: cle_id
2361: FROM okc_rule_groups_v
2362: WHERE dnz_chr_id = p_chr_id
2363: AND cle_id = p_cle_id
2364: AND rgd_code = 'LALEVL';
2365:

Line 2369: FROM okc_rule_groups_v

2365:
2366: CURSOR old_lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2367: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2368: SELECT id
2369: FROM okc_rule_groups_v
2370: WHERE dnz_chr_id = p_chr_id
2371: AND rgd_code = 'LALEVL'
2372: AND (cle_id = p_cle_id
2373: OR ( cle_id IS NULL

Line 2448: FROM okc_rule_groups_v

2444:
2445: CURSOR lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
2446: SELECT id,
2447: cle_id
2448: FROM okc_rule_groups_v
2449: WHERE dnz_chr_id = p_chr_id
2450: AND cle_id IS NULL -- Bug 2376998
2451: AND rgd_code = 'LALEVL';
2452:

Line 2456: FROM okc_rule_groups_v

2452:
2453: CURSOR old_lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2454: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2455: SELECT id
2456: FROM okc_rule_groups_v
2457: WHERE dnz_chr_id = p_chr_id
2458: AND rgd_code = 'LALEVL'
2459: AND (cle_id = p_cle_id
2460: OR ( cle_id IS NULL