DBA Data[Home] [Help]

APPS.OKL_CONTRACT_PVT dependencies on OKC_RULE_GROUPS_B

Line 1755: From okc_rule_groups_b rgp

1751:
1752: --cursor to get tax owner rule group
1753: Cursor town_rgp_exists_csr (pchrid Number) is
1754: select id
1755: From okc_rule_groups_b rgp
1756: Where rgp.chr_id = pchrid
1757: and rgp.dnz_chr_id = pchrid
1758: and rgp.rgd_code = 'LATOWN';
1759:

Line 1821: okc_rule_groups_b rgpb

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
1825: and rgpb.rgd_code = 'LARLES'