APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKC_RULE_GROUPS_B

Line 1192: FROM okc_rule_groups_b

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

Line 1723: FROM okc_rule_groups_b

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

Line 4156: FROM okc_rule_groups_b rgp, okc_subclass_rg_defs rg_defs

4152: AND olav.ID = p_lap_id;
4153:
4154: CURSOR c_rgpv (p_chr_tmp_id okl_leaseapp_templ_versions_v.CONTRACT_TEMPLATE_ID%TYPE)IS
4155: SELECT rgp.id
4156: FROM okc_rule_groups_b rgp, okc_subclass_rg_defs rg_defs
4157: WHERE rgp.dnz_chr_id = p_chr_tmp_id
4158: AND rgp.rgd_code = rg_defs.rgd_code
4159: AND rg_defs.scs_code = 'LEASE'
4160: AND rgp.cle_id IS NULL