APPS.OKL_DEAL_CREAT_PVT dependencies on OKC_RULES_B

Line 2710: l_rule_info_cat okc_rules_b.rule_information_category%TYPE := NULL;

2706: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := NULL;
2707: x_converted_amount NUMBER := NULL;
2708:
2709: l_rgd_code okc_rule_groups_b.rgd_code%TYPE := NULL;
2710: l_rule_info_cat okc_rules_b.rule_information_category%TYPE := NULL;
2711: l_rule_id NUMBER := NULL;
2712: l_rule_segment VARCHAR2(250) := NULL;
2713:
2714: l_no_data_found BOOLEAN := TRUE;

Line 2770: from okc_rule_groups_b rgp, okc_rules_b rul

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

Line 4848: FROM okc_rules_b rul,

4844:
4845: --Added by bkatraga for bug 9343568
4846: CURSOR c_check_rule(p_chr_id NUMBER, p_rgd_code VARCHAR2, p_rule_cat VARCHAR2) IS
4847: SELECT count(1)
4848: FROM okc_rules_b rul,
4849: okc_rule_groups_b rgp
4850: WHERE rgp.chr_id = p_chr_id
4851: AND rgp.rgd_code = p_rgd_code
4852: AND rul.rgp_id = rgp.id

Line 6742: okc_rules_b rul

6738:
6739: CURSOR get_larles_csr IS
6740: SELECT rul.rule_information1
6741: FROM okc_rule_groups_b rgp,
6742: okc_rules_b rul
6743: WHERE rgp.id = rul.rgp_id
6744: AND rgp.rgd_code = 'LARLES'
6745: AND rul.rule_information_category = 'LARLES'
6746: AND rgp.dnz_chr_id = p_durv_rec.chr_id

Line 6765: FROM okc_rules_b rul,

6761: AND lse.lty_code = 'FREE_FORM1';
6762:
6763: CURSOR get_lacpln_csr IS
6764: SELECT rul.rule_information1
6765: FROM okc_rules_b rul,
6766: okc_rule_groups_b rgp
6767: WHERE rgp.id = rul.rgp_id
6768: AND rul.rule_information_category = 'LACPLN'
6769: AND rgp.RGD_CODE = 'LACPLN'

Line 9459: okc_rules_b rul

9455: CURSOR c_eot(p_chr_id NUMBER) IS
9456: SELECT rul.rule_information1 eot_option_code,
9457: rul.rule_information2 eot_option_amount
9458: FROM okc_rule_groups_b rgp,
9459: okc_rules_b rul
9460: WHERE rgp.dnz_chr_id = p_chr_id
9461: AND rgp.rgd_code = 'AMTFOC'
9462: AND rgp.dnz_chr_id = rgp.dnz_chr_id
9463: AND rul.rgp_id = rgp.id

Line 9485: l_eot_option_code okc_rules_b.rule_information1%TYPE;

9481: AND cleb.lse_id = lseb.id
9482: AND lseb.lty_code = 'FEE'
9483: AND kle.fee_purpose_code = 'RVI';
9484:
9485: l_eot_option_code okc_rules_b.rule_information1%TYPE;
9486: l_currency_code okc_k_headers_b.currency_code%TYPE;
9487: l_total_financed_amount NUMBER;
9488: l_total_funded NUMBER;
9489: l_total_subsidies NUMBER;