APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKC_RULE_GROUPS_V

Line 1309: FROM OKC_RULE_GROUPS_V rgp,

1305: rule.ans_set_jtot_object_code,
1306: rule.ans_set_jtot_object_id1,
1307: rule.ans_set_jtot_object_id2,
1308: rule.DISPLAY_SEQUENCE
1309: FROM OKC_RULE_GROUPS_V rgp,
1310: Okc_Rules_V rule
1311: WHERE rgp.id = rule.rgp_id
1312: AND rgp.rgd_code = p_rgd_code
1313: AND RULE_INFORMATION_CATEGORY = p_rule_code

Line 1642: FROM okc_rule_groups_v

1638: ,creation_date
1639: ,last_updated_by
1640: ,last_update_date
1641: ,last_update_login
1642: FROM okc_rule_groups_v
1643: WHERE dnz_chr_id = p_chr_id
1644: AND cle_id IS NULL
1645: AND rgd_code = 'LALEVL';
1646:

Line 1650: FROM okc_rule_groups_v

1646:
1647: CURSOR orig_rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1648:
1649: SELECT id
1650: FROM okc_rule_groups_v
1651: WHERE dnz_chr_id = p_chr_id
1652: AND cle_id IS NULL
1653: AND rgd_code = 'LALEVL';
1654:

Line 1905: FROM okc_rule_groups_v

1901: ,creation_date
1902: ,last_updated_by
1903: ,last_update_date
1904: ,last_update_login
1905: FROM okc_rule_groups_v
1906: WHERE dnz_chr_id = p_chr_id
1907: AND rgd_code = 'LALEVL';
1908:
1909: CURSOR orig_cle_csr(p_cle_id OKC_K_LINES_V.ID%TYPE) IS

Line 1917: FROM okc_rule_groups_v

1913:
1914: CURSOR orig_rgp_csr(p_cle_id OKC_K_LINES_V.ID%TYPE,
1915: p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1916: SELECT id
1917: FROM okc_rule_groups_v
1918: WHERE dnz_chr_id = p_chr_id
1919: AND ((cle_id = p_cle_id AND p_cle_id IS NOT NULL)
1920: OR
1921: cle_id IS NULL AND p_cle_id IS NULL)

Line 1926: FROM okc_rule_groups_v

1922: AND rgd_code = 'LALEVL';
1923:
1924: CURSOR del_rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1925: SELECT id
1926: FROM okc_rule_groups_v
1927: WHERE dnz_chr_id = p_chr_id
1928: AND rgd_code = 'LALEVL';
1929:
1930: CURSOR rule_csr(p_rgp_id NUMBER) IS

Line 4686: FROM okc_rule_groups_v

4682: AND line.dnz_chr_id = parent_cle.dnz_chr_id;
4683:
4684: CURSOR del_rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4685: SELECT id
4686: FROM okc_rule_groups_v
4687: WHERE dnz_chr_id = p_chr_id
4688: AND rgd_code = 'LALEVL';
4689:
4690: CURSOR rule_csr(p_rgp_id NUMBER) IS