APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKC_RULE_GROUPS_V

Line 2793: okc_rule_groups_v rgp

2789: CURSOR l_strm_type_rul_csr IS
2790: select rgp.id,
2791: rul.id
2792: from okc_rules_v rul,
2793: okc_rule_groups_v rgp
2794: where rgp.id = rul.rgp_id
2795: and rgp.rgd_code = 'LAPSTH'
2796: and rul.rule_information_category = 'LASTRM'
2797: and rgp.cle_id = p_fee_types_rec.line_id

Line 3429: from okc_rule_groups_v

3425: l_api_version CONSTANT NUMBER := 1.0;
3426:
3427: CURSOR l_lapsth_rgp_csr IS
3428: select id
3429: from okc_rule_groups_v
3430: where cle_id = p_cle_id
3431: and chr_id is null
3432: and dnz_chr_id = p_chr_id
3433: and rgd_code = 'LAPSTH';

Line 3439: okc_rule_groups_v rgp

3435: CURSOR l_strm_type_rul_csr IS
3436: select rgp.id,
3437: rul.id
3438: from okc_rules_v rul,
3439: okc_rule_groups_v rgp
3440: where rgp.id = rul.rgp_id
3441: and rgp.rgd_code = 'LAPSTH'
3442: and rul.rule_information_category = 'LASTRM'
3443: and rgp.cle_id = p_cle_id

Line 3698: okc_rule_groups_v rgp

3694: CURSOR l_strm_type_rul_csr IS
3695: select rul.object1_id1,
3696: rul.object1_id2
3697: from okc_rules_v rul,
3698: okc_rule_groups_v rgp
3699: where rgp.id = rul.rgp_id
3700: and rgp.rgd_code = 'LAPSTH'
3701: and rul.rule_information_category = 'LASTRM'
3702: and rgp.cle_id = p_cle_id

Line 5418: FROM okc_rules_v rul, okc_rule_groups_v rgb

5414:
5415: -- cursor to get check box value
5416: CURSOR get_rvi_check_value_csr (p_chr_id in NUMBER) IS
5417: SELECT rule_information1
5418: FROM okc_rules_v rul, okc_rule_groups_v rgb
5419: WHERE rul.dnz_chr_id = p_chr_id AND
5420: rule_information_category = 'LARVAU' AND
5421: rgb.id = rul.rgp_id AND rgd_code like 'LARVIN';
5422: