APPS.OKL_CONTRACT_PVT dependencies on OKC_RULES_B

Line 1734: From okc_rules_b rul

1730: --cursor to get tax owner rule
1731: Cursor town_rul_csr (pchrid number, prgpid number) is
1732: Select rule_information1 tax_owner,
1733: id
1734: From okc_rules_b rul
1735: where rul.rgp_id = prgpid
1736: and rul.dnz_chr_id = pchrid
1737: and rul.rule_information_category = 'LATOWN'
1738: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';

Line 1740: l_town_rul okc_rules_b.rule_information1%TYPE;

1736: and rul.dnz_chr_id = pchrid
1737: and rul.rule_information_category = 'LATOWN'
1738: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
1739:
1740: l_town_rul okc_rules_b.rule_information1%TYPE;
1741: l_town_rul_id okc_rules_b.id%TYPE;
1742:
1743: l_latown_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
1744: lx_latown_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;

Line 1741: l_town_rul_id okc_rules_b.id%TYPE;

1737: and rul.rule_information_category = 'LATOWN'
1738: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
1739:
1740: l_town_rul okc_rules_b.rule_information1%TYPE;
1741: l_town_rul_id okc_rules_b.id%TYPE;
1742:
1743: l_latown_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
1744: lx_latown_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
1745:

Line 1788: from okc_rules_b rulb,

1784:
1785: --Bug# 3631094
1786: Cursor l_release_asset_yn_csr (p_chr_id in number) is
1787: select nvl(rulb.rule_information1,'N') release_Asset_yn
1788: from okc_rules_b rulb,
1789: okc_rule_groups_b rgpb
1790: where rulb.rule_information_category = 'LARLES'
1791: and rulb.rgp_id = rgpb.id
1792: and rulb.dnz_chr_id = rgpb.dnz_chr_id

Line 1797: l_release_asset_yn okc_rules_b.rule_information1%TYPE;

1793: and rgpb.rgd_code = 'LARLES'
1794: and rgpb.chr_id = p_chr_id
1795: and rgpb.dnz_chr_id = p_chr_id;
1796:
1797: l_release_asset_yn okc_rules_b.rule_information1%TYPE;
1798: --Bug# 3631094
1799:
1800: --cursor to get multi-gaap reporting book transaction
1801: cursor l_txd_csr (p_book_type_code in varchar2,