APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKC_RULES_B

Line 727: FROM okc_rules_b

723: SELECT object1_id1 frequency, object2_id1 laslh_id, fnd_date.canonical_to_date(rule_information2) start_date,
724: rule_information3 periods, rule_information6 amount,
725: rule_information5 payment_structure, rule_information13 rate,
726: rule_information7 stub_days, rule_information8 stub_amount, rule_information10 arrears
727: FROM okc_rules_b
728: WHERE id = p_rul_id;
729: BEGIN
730: FOR l_lasll_csr_rec IN find_lasll_dtls_csr(p_rul_id => p_payment_levels_rec.payment_level_id)
731: LOOP

Line 1201: FROM okc_rules_b

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
1202: WHERE rgp_id = p_rgp_id AND rule_information_category = 'LASLH';
1203: CURSOR RGP_CLE_CSR(P_CHR_ID IN NUMBER, P_CLE_ID IN NUMBER)IS
1204: SELECT
1205: ID

Line 1732: FROM okc_rules_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
1732: FROM okc_rules_b
1733: WHERE rgp_id = p_rgp_id AND rule_information_category = 'LAFEXP';
1734: -- find the rule information for LAFREQ
1735: CURSOR find_lafreq_dtls_csr(p_rgp_id NUMBER) IS
1736: SELECT id, object1_id1 frequency

Line 1737: FROM okc_rules_b

1733: WHERE rgp_id = p_rgp_id AND rule_information_category = 'LAFEXP';
1734: -- find the rule information for LAFREQ
1735: CURSOR find_lafreq_dtls_csr(p_rgp_id NUMBER) IS
1736: SELECT id, object1_id1 frequency
1737: FROM okc_rules_b
1738: WHERE rgp_id = p_rgp_id AND rule_information_category = 'LAFREQ';
1739: BEGIN
1740: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1741: -- check for logging on PROCEDURE level