APPS.OKL_DEAL_CREAT_PVT dependencies on OKC_RULES_B

Line 2707: l_rule_info_cat okc_rules_b.rule_information_category%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:
2711: l_no_data_found BOOLEAN := TRUE;

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 6697: okc_rules_b rul

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'
6701: AND rgp.dnz_chr_id = p_durv_rec.chr_id

Line 6720: FROM okc_rules_b rul,

6716: AND lse.lty_code = 'FREE_FORM1';
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'

Line 9360: okc_rules_b rul

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
9364: AND rul.rgp_id = rgp.id

Line 9386: l_eot_option_code okc_rules_b.rule_information1%TYPE;

9382: AND cleb.lse_id = lseb.id
9383: AND lseb.lty_code = 'FEE'
9384: AND kle.fee_purpose_code = 'RVI';
9385:
9386: l_eot_option_code okc_rules_b.rule_information1%TYPE;
9387: l_currency_code okc_k_headers_b.currency_code%TYPE;
9388: l_total_financed_amount NUMBER;
9389: l_total_funded NUMBER;
9390: l_total_subsidies NUMBER;