APPS.OKL_DEAL_CREAT_PVT dependencies on OKC_RULE_GROUPS_B

Line 1159: FROM okc_rule_groups_b rgp, okc_subclass_rg_defs rg_defs

1155: AND id = p_id;
1156:
1157: CURSOR c_rgpv IS
1158: SELECT rgp.id
1159: FROM okc_rule_groups_b rgp, okc_subclass_rg_defs rg_defs
1160: WHERE rgp.dnz_chr_id = p_source_chr_id
1161: AND rgp.rgd_code = rg_defs.rgd_code
1162: AND rg_defs.scs_code = 'LEASE'
1163: AND rgp.cle_id IS NULL

Line 2706: l_rgd_code okc_rule_groups_b.rgd_code%TYPE := NULL;

2702: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := NULL;
2703: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := NULL;
2704: x_converted_amount NUMBER := NULL;
2705:
2706: l_rgd_code okc_rule_groups_b.rgd_code%TYPE := NULL;
2707: l_rule_info_cat okc_rules_b.rule_information_category%TYPE := NULL;
2708: l_rule_id NUMBER := NULL;
2709: l_rule_segment VARCHAR2(250) := NULL;
2710:

Line 2767: from okc_rule_groups_b rgp, okc_rules_b rul

2763: ;
2764: CURSOR c_rule_csr (p_rgp_id IN NUMBER) IS
2765: --Start modified abhsaxen for performance SQLID 20562755
2766: select rgp.rgd_code,rul.rule_information_category,rul.id
2767: from okc_rule_groups_b rgp, okc_rules_b rul
2768: where rgp.id = rul.rgp_id
2769: and rul.dnz_chr_id = p_dest_id
2770: and rgp.id = p_rgp_id
2771: and exists (

Line 4833: FROM okc_rule_groups_b

4829: FROM okl_system_params;
4830:
4831: CURSOR c_rule_group(p_chr_id NUMBER, p_rgd_code VARCHAR2) IS
4832: SELECT id,rgd_code
4833: FROM okc_rule_groups_b
4834: WHERE dnz_chr_id = p_chr_id
4835: AND rgd_code = p_rgd_code;
4836:
4837: CURSOR c_orig_system_source(p_chr_id NUMBER) IS

Line 6696: FROM okc_rule_groups_b rgp,

6692: AND CHR.id = p_durv_rec.chr_id;
6693:
6694: CURSOR get_larles_csr IS
6695: SELECT rul.rule_information1
6696: FROM okc_rule_groups_b rgp,
6697: okc_rules_b rul
6698: WHERE rgp.id = rul.rgp_id
6699: AND rgp.rgd_code = 'LARLES'
6700: AND rul.rule_information_category = 'LARLES'

Line 6721: okc_rule_groups_b rgp

6717:
6718: CURSOR get_lacpln_csr IS
6719: SELECT rul.rule_information1
6720: FROM okc_rules_b rul,
6721: okc_rule_groups_b rgp
6722: WHERE rgp.id = rul.rgp_id
6723: AND rul.rule_information_category = 'LACPLN'
6724: AND rgp.RGD_CODE = 'LACPLN'
6725: AND rul.dnz_chr_id = rgp.dnz_chr_id

Line 9359: FROM okc_rule_groups_b rgp,

9355:
9356: CURSOR c_eot(p_chr_id NUMBER) IS
9357: SELECT rul.rule_information1 eot_option_code,
9358: rul.rule_information2 eot_option_amount
9359: FROM okc_rule_groups_b rgp,
9360: okc_rules_b rul
9361: WHERE rgp.dnz_chr_id = p_chr_id
9362: AND rgp.rgd_code = 'AMTFOC'
9363: AND rgp.dnz_chr_id = rgp.dnz_chr_id