DBA Data[Home] [Help]

APPS.OKL_CONTRACT_PVT dependencies on OKC_RULE_GROUPS_B

Line 1723: From okc_rule_groups_b rgp

1719:
1720: --cursor to get tax owner rule group
1721: Cursor town_rgp_exists_csr (pchrid Number) is
1722: select id
1723: From okc_rule_groups_b rgp
1724: Where rgp.chr_id = pchrid
1725: and rgp.dnz_chr_id = pchrid
1726: and rgp.rgd_code = 'LATOWN';
1727:

Line 1789: okc_rule_groups_b rgpb

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