APPS.OKL_DEAL_CREATE_PUB dependencies on OKC_RULE_GROUPS_B

Line 1160: FROM okc_rule_groups_b rgp, okc_subclass_rg_defs rg_defs

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

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

2713: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%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:

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 6577: FROM okc_rule_groups_b rgp,

6573:
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'

Line 6602: okc_rule_groups_b rgp

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'
6606: AND rul.dnz_chr_id = rgp.dnz_chr_id