APPS.OKL_DEAL_CREATE_PUB dependencies on OKC_RULES_B

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

2717: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := NULL;
2718: x_converted_amount NUMBER := NULL;
2719:
2720: l_rgd_code okc_rule_groups_b.rgd_code%TYPE := NULL;
2721: l_rule_info_cat okc_rules_b.rule_information_category%TYPE := NULL;
2722: l_rule_id NUMBER := NULL;
2723: l_rule_segment VARCHAR2(250) := NULL;
2724:
2725: l_no_data_found BOOLEAN := TRUE;

Line 2790: from okc_rule_groups_b rgp, okc_rules_b rul

2786: ;
2787: CURSOR c_rule_csr (p_rgp_id IN NUMBER) IS
2788: --Start modified abhsaxen for performance SQLID 20562755
2789: select rgp.rgd_code,rul.rule_information_category,rul.id
2790: from okc_rule_groups_b rgp, okc_rules_b rul
2791: where rgp.id = rul.rgp_id
2792: and rul.dnz_chr_id = p_dest_id
2793: and rgp.id = p_rgp_id
2794: and exists (

Line 6581: okc_rules_b rul

6577:
6578: CURSOR get_larles_csr IS
6579: SELECT rul.rule_information1
6580: FROM okc_rule_groups_b rgp,
6581: okc_rules_b rul
6582: WHERE rgp.id = rul.rgp_id
6583: AND rgp.rgd_code = 'LARLES'
6584: AND rul.rule_information_category = 'LARLES'
6585: AND rgp.dnz_chr_id = p_durv_rec.chr_id

Line 6604: FROM okc_rules_b rul,

6600: AND lse.lty_code = 'FREE_FORM1';
6601:
6602: CURSOR get_lacpln_csr IS
6603: SELECT rul.rule_information1
6604: FROM okc_rules_b rul,
6605: okc_rule_groups_b rgp
6606: WHERE rgp.id = rul.rgp_id
6607: AND rul.rule_information_category = 'LACPLN'
6608: AND rgp.RGD_CODE = 'LACPLN'