APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKC_RULES_B

Line 725: FROM okc_rules_b

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

Line 1196: FROM okc_rules_b

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
1197: WHERE rgp_id = p_rgp_id AND rule_information_category = 'LASLH';
1198: CURSOR RGP_CLE_CSR(P_CHR_ID IN NUMBER, P_CLE_ID IN NUMBER)IS
1199: SELECT
1200: ID

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

Line 1733: FROM okc_rules_b

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