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 2720: l_rgd_code okc_rule_groups_b.rgd_code%TYPE := NULL;

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

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

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

Line 6605: okc_rule_groups_b rgp

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