APPS.OKL_DEAL_CREATE_PUB dependencies on OKC_RULES_B

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

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

Line 2787: from okc_rule_groups_b rgp, okc_rules_b rul

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

Line 6578: okc_rules_b rul

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

Line 6601: FROM okc_rules_b rul,

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