APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKC_RULE_GROUPS_V

Line 1338: FROM OKC_RULE_GROUPS_V rgp,

1334: rule.ans_set_jtot_object_code,
1335: rule.ans_set_jtot_object_id1,
1336: rule.ans_set_jtot_object_id2,
1337: rule.DISPLAY_SEQUENCE
1338: FROM OKC_RULE_GROUPS_V rgp,
1339: Okc_Rules_V rule
1340: WHERE rgp.id = rule.rgp_id
1341: AND rgp.rgd_code = p_rgd_code
1342: AND RULE_INFORMATION_CATEGORY = p_rule_code

Line 1671: FROM okc_rule_groups_v

1667: ,creation_date
1668: ,last_updated_by
1669: ,last_update_date
1670: ,last_update_login
1671: FROM okc_rule_groups_v
1672: WHERE dnz_chr_id = p_chr_id
1673: AND cle_id IS NULL
1674: AND rgd_code = 'LALEVL';
1675:

Line 1679: FROM okc_rule_groups_v

1675:
1676: CURSOR orig_rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1677:
1678: SELECT id
1679: FROM okc_rule_groups_v
1680: WHERE dnz_chr_id = p_chr_id
1681: AND cle_id IS NULL
1682: AND rgd_code = 'LALEVL';
1683:

Line 1934: FROM okc_rule_groups_v

1930: ,creation_date
1931: ,last_updated_by
1932: ,last_update_date
1933: ,last_update_login
1934: FROM okc_rule_groups_v
1935: WHERE dnz_chr_id = p_chr_id
1936: AND rgd_code = 'LALEVL';
1937:
1938: CURSOR orig_cle_csr(p_cle_id OKC_K_LINES_V.ID%TYPE) IS

Line 1946: FROM okc_rule_groups_v

1942:
1943: CURSOR orig_rgp_csr(p_cle_id OKC_K_LINES_V.ID%TYPE,
1944: p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1945: SELECT id
1946: FROM okc_rule_groups_v
1947: WHERE dnz_chr_id = p_chr_id
1948: AND ((cle_id = p_cle_id AND p_cle_id IS NOT NULL)
1949: OR
1950: cle_id IS NULL AND p_cle_id IS NULL)

Line 1955: FROM okc_rule_groups_v

1951: AND rgd_code = 'LALEVL';
1952:
1953: CURSOR del_rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1954: SELECT id
1955: FROM okc_rule_groups_v
1956: WHERE dnz_chr_id = p_chr_id
1957: AND rgd_code = 'LALEVL';
1958:
1959: CURSOR rule_csr(p_rgp_id NUMBER) IS

Line 5577: FROM okc_rule_groups_v

5573: AND line.sts_code <> 'ABANDONED';
5574:
5575: CURSOR del_rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
5576: SELECT id
5577: FROM okc_rule_groups_v
5578: WHERE dnz_chr_id = p_chr_id
5579: AND rgd_code = 'LALEVL';
5580:
5581: CURSOR rule_csr(p_rgp_id NUMBER) IS