APPS.OKL_CONTRACT_PVT dependencies on OKC_RULES_B

Line 1766: From okc_rules_b rul

1762: --cursor to get tax owner rule
1763: Cursor town_rul_csr (pchrid number, prgpid number) is
1764: Select rule_information1 tax_owner,
1765: id
1766: From okc_rules_b rul
1767: where rul.rgp_id = prgpid
1768: and rul.dnz_chr_id = pchrid
1769: and rul.rule_information_category = 'LATOWN'
1770: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';

Line 1772: l_town_rul okc_rules_b.rule_information1%TYPE;

1768: and rul.dnz_chr_id = pchrid
1769: and rul.rule_information_category = 'LATOWN'
1770: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
1771:
1772: l_town_rul okc_rules_b.rule_information1%TYPE;
1773: l_town_rul_id okc_rules_b.id%TYPE;
1774:
1775: l_latown_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
1776: lx_latown_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;

Line 1773: l_town_rul_id okc_rules_b.id%TYPE;

1769: and rul.rule_information_category = 'LATOWN'
1770: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
1771:
1772: l_town_rul okc_rules_b.rule_information1%TYPE;
1773: l_town_rul_id okc_rules_b.id%TYPE;
1774:
1775: l_latown_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
1776: lx_latown_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
1777:

Line 1820: from okc_rules_b rulb,

1816:
1817: --Bug# 3631094
1818: Cursor l_release_asset_yn_csr (p_chr_id in number) is
1819: select nvl(rulb.rule_information1,'N') release_Asset_yn
1820: from okc_rules_b rulb,
1821: okc_rule_groups_b rgpb
1822: where rulb.rule_information_category = 'LARLES'
1823: and rulb.rgp_id = rgpb.id
1824: and rulb.dnz_chr_id = rgpb.dnz_chr_id

Line 1829: l_release_asset_yn okc_rules_b.rule_information1%TYPE;

1825: and rgpb.rgd_code = 'LARLES'
1826: and rgpb.chr_id = p_chr_id
1827: and rgpb.dnz_chr_id = p_chr_id;
1828:
1829: l_release_asset_yn okc_rules_b.rule_information1%TYPE;
1830: --Bug# 3631094
1831:
1832: --cursor to get multi-gaap reporting book transaction
1833: --Bug# 15992711 : Start Modifications