APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKC_RULE_GROUPS_V

Line 2806: okc_rule_groups_v rgp

2802: CURSOR l_strm_type_rul_csr IS
2803: select rgp.id,
2804: rul.id
2805: from okc_rules_v rul,
2806: okc_rule_groups_v rgp
2807: where rgp.id = rul.rgp_id
2808: and rgp.rgd_code = 'LAPSTH'
2809: and rul.rule_information_category = 'LASTRM'
2810: and rgp.cle_id = p_fee_types_rec.line_id

Line 3442: from okc_rule_groups_v

3438: l_api_version CONSTANT NUMBER := 1.0;
3439:
3440: CURSOR l_lapsth_rgp_csr IS
3441: select id
3442: from okc_rule_groups_v
3443: where cle_id = p_cle_id
3444: and chr_id is null
3445: and dnz_chr_id = p_chr_id
3446: and rgd_code = 'LAPSTH';

Line 3452: okc_rule_groups_v rgp

3448: CURSOR l_strm_type_rul_csr IS
3449: select rgp.id,
3450: rul.id
3451: from okc_rules_v rul,
3452: okc_rule_groups_v rgp
3453: where rgp.id = rul.rgp_id
3454: and rgp.rgd_code = 'LAPSTH'
3455: and rul.rule_information_category = 'LASTRM'
3456: and rgp.cle_id = p_cle_id

Line 3711: okc_rule_groups_v rgp

3707: CURSOR l_strm_type_rul_csr IS
3708: select rul.object1_id1,
3709: rul.object1_id2
3710: from okc_rules_v rul,
3711: okc_rule_groups_v rgp
3712: where rgp.id = rul.rgp_id
3713: and rgp.rgd_code = 'LAPSTH'
3714: and rul.rule_information_category = 'LASTRM'
3715: and rgp.cle_id = p_cle_id

Line 5431: FROM okc_rules_v rul, okc_rule_groups_v rgb

5427:
5428: -- cursor to get check box value
5429: CURSOR get_rvi_check_value_csr (p_chr_id in NUMBER) IS
5430: SELECT rule_information1
5431: FROM okc_rules_v rul, okc_rule_groups_v rgb
5432: WHERE rul.dnz_chr_id = p_chr_id AND
5433: rule_information_category = 'LARVAU' AND
5434: rgb.id = rul.rgp_id AND rgd_code like 'LARVIN';
5435: