APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKC_RULE_GROUPS_B

Line 1197: FROM okc_rule_groups_b

1193: l_pricing_engine VARCHAR2(2) := 'NA';
1194: l_rgrp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
1195: CURSOR find_payment_hdr_csr IS
1196: SELECT id
1197: FROM okc_rule_groups_b
1198: WHERE rgd_code = 'LALEVL' AND cle_id = p_cle_id;
1199: CURSOR find_laslh_dtls_csr(p_rgp_id NUMBER) IS
1200: SELECT id, object1_id1 payment_type_id, rule_information2 rate_type
1201: FROM okc_rules_b

Line 1727: FROM okc_rule_groups_b

1723: l_rgp_id NUMBER;
1724: -- find the LAFEXP rule group id
1725: CURSOR find_fexprg_csr IS
1726: SELECT id
1727: FROM okc_rule_groups_b
1728: WHERE rgd_code = 'LAFEXP' AND cle_id = p_cle_id;
1729: -- find the rule information for LAFEXP
1730: CURSOR find_lafexp_dtls_csr(p_rgp_id NUMBER) IS
1731: SELECT id, rule_information1 periods, rule_information2 periodic_amount

Line 4263: FROM okc_rule_groups_b rgp, okc_subclass_rg_defs rg_defs

4259: AND olav.ID = p_lap_id;
4260:
4261: CURSOR c_rgpv (p_chr_tmp_id okl_leaseapp_templ_versions_v.CONTRACT_TEMPLATE_ID%TYPE)IS
4262: SELECT rgp.id
4263: FROM okc_rule_groups_b rgp, okc_subclass_rg_defs rg_defs
4264: WHERE rgp.dnz_chr_id = p_chr_tmp_id
4265: AND rgp.rgd_code = rg_defs.rgd_code
4266: AND rg_defs.scs_code = 'LEASE'
4267: AND rgp.cle_id IS NULL