APPS.OKL_VP_SYNC_CR_PVT dependencies on OKC_RULE_GROUPS_V

Line 2441: FROM okc_rule_groups_v orig

2437: ,cp_creq_chr_id okc_k_headers_b.id%TYPE) IS
2438: SELECT orig.id
2439: ,orig.dnz_chr_id
2440: ,orig.rgd_code
2441: FROM okc_rule_groups_v orig
2442: WHERE chr_id = cp_orig_chr_id
2443: AND cle_id IS NULL
2444: AND dnz_chr_id = cp_orig_chr_id
2445: AND NOT EXISTS (

Line 2447: FROM okc_rule_groups_v creq

2443: AND cle_id IS NULL
2444: AND dnz_chr_id = cp_orig_chr_id
2445: AND NOT EXISTS (
2446: SELECT 'X'
2447: FROM okc_rule_groups_v creq
2448: WHERE creq.chr_id = cp_creq_chr_id
2449: AND creq.rgd_code = orig.rgd_code
2450: AND creq.dnz_chr_id = cp_creq_chr_id
2451: AND creq.cle_id IS NULL);

Line 2460: FROM okc_rule_groups_v creq

2456: ,cp_creq_chr_id okc_k_headers_b.id%TYPE) IS
2457: SELECT creq.id
2458: ,creq.dnz_chr_id
2459: ,creq.rgd_code
2460: FROM okc_rule_groups_v creq
2461: WHERE chr_id = cp_creq_chr_id
2462: AND cle_id IS NULL
2463: AND dnz_chr_id = cp_creq_chr_id
2464: AND EXISTS (

Line 2466: FROM okc_rule_groups_v orig

2462: AND cle_id IS NULL
2463: AND dnz_chr_id = cp_creq_chr_id
2464: AND EXISTS (
2465: SELECT 'X'
2466: FROM okc_rule_groups_v orig
2467: WHERE orig.chr_id = cp_orig_chr_id
2468: AND orig.rgd_code = creq.rgd_code
2469: AND orig.dnz_chr_id = cp_orig_chr_id
2470: AND orig.cle_id IS NULL);

Line 2494: FROM okc_rule_groups_v creq

2490: SELECT creq.id
2491: ,creq.dnz_chr_id
2492: ,creq.rgd_code
2493: ,creq.rgp_type
2494: FROM okc_rule_groups_v creq
2495: WHERE chr_id = cp_creq_chr_id
2496: AND cle_id IS NULL
2497: AND dnz_chr_id = cp_creq_chr_id
2498: AND NOT EXISTS (

Line 2500: FROM okc_rule_groups_v orig

2496: AND cle_id IS NULL
2497: AND dnz_chr_id = cp_creq_chr_id
2498: AND NOT EXISTS (
2499: SELECT 'X'
2500: FROM okc_rule_groups_v orig
2501: WHERE orig.chr_id = cp_orig_chr_id
2502: AND orig.rgd_code = creq.rgd_code
2503: AND orig.dnz_chr_id = cp_orig_chr_id
2504: AND orig.cle_id IS NULL);