APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKC_RULES_B

Line 183: FROM okc_rules_b rul

179: WHERE NVL (CHR.orig_system_source_code, 'XXXX') <> 'OKL_RELEASE'
180: AND CHR.ID = p_chr_id
181: AND EXISTS (
182: SELECT '1'
183: FROM okc_rules_b rul
184: WHERE rul.dnz_chr_id = CHR.ID
185: AND rul.rule_information_category = 'LARLES'
186: AND NVL (rule_information1, 'N') = 'Y');
187:

Line 1940: rlcat okc_rules_b.rule_information_category%TYPE,

1936: n NUMBER;
1937:
1938: CURSOR l_rl_csr1 (
1939: rgcode okc_rule_groups_b.rgd_code%TYPE,
1940: rlcat okc_rules_b.rule_information_category%TYPE,
1941: chrid NUMBER,
1942: cleid NUMBER
1943: ) IS
1944: SELECT crl.ID slh_id,

Line 1953: FROM okc_rule_groups_b crg, okc_rules_b crl

1949: crl.rule_information5,
1950: crl.rule_information6,
1951: crl.rule_information7,
1952: crl.rule_information10
1953: FROM okc_rule_groups_b crg, okc_rules_b crl
1954: WHERE crl.rgp_id = crg.ID
1955: AND crg.rgd_code = rgcode
1956: AND crl.rule_information_category = rlcat
1957: AND crg.dnz_chr_id = chrid