APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKC_RULES_B

Line 98: FROM okc_rules_b rul

94: WHERE NVL (CHR.orig_system_source_code, 'XXXX') <> 'OKL_RELEASE'
95: AND CHR.ID = p_chr_id
96: AND EXISTS (
97: SELECT '1'
98: FROM okc_rules_b rul
99: WHERE rul.dnz_chr_id = CHR.ID
100: AND rul.rule_information_category = 'LARLES'
101: AND NVL (rule_information1, 'N') = 'Y');
102:

Line 1636: rlcat okc_rules_b.rule_information_category%TYPE,

1632: n NUMBER;
1633:
1634: CURSOR l_rl_csr1 (
1635: rgcode okc_rule_groups_b.rgd_code%TYPE,
1636: rlcat okc_rules_b.rule_information_category%TYPE,
1637: chrid NUMBER,
1638: cleid NUMBER
1639: ) IS
1640: SELECT crl.ID slh_id,

Line 1649: FROM okc_rule_groups_b crg, okc_rules_b crl

1645: crl.rule_information5,
1646: crl.rule_information6,
1647: crl.rule_information7,
1648: crl.rule_information10
1649: FROM okc_rule_groups_b crg, okc_rules_b crl
1650: WHERE crl.rgp_id = crg.ID
1651: AND crg.rgd_code = rgcode
1652: AND crl.rule_information_category = rlcat
1653: AND crg.dnz_chr_id = chrid