APPS.OKL_SPLIT_ASSET_PVT dependencies on OKC_RULE_GROUPS_B

Line 720: FROM OKC_RULE_GROUPS_B crg,

716: CURSOR l_pmnt_strm_check(p_chrId NUMBER,
717: p_cle_id NUMBER
718: ) IS
719: SELECT crl.id
720: FROM OKC_RULE_GROUPS_B crg,
721: OKC_RULES_B crl,
722: OKL_STRM_TYPE_B stty
723: WHERE stty.id = crl.object1_id1
724: AND stty.stream_type_purpose = 'PRINCIPAL_PAYMENT'

Line 732: rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

728: AND crg.dnz_chr_id = p_chrId
729: and cle_id = p_cle_id;
730:
731: CURSOR l_pmnt_strm_check2(
732: rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
733: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
734: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,
735: chrId NUMBER) IS
736: SELECT crg.cle_id,

Line 747: FROM OKC_RULE_GROUPS_B crg,

743: crl.RULE_INFORMATION5,
744: crl.RULE_INFORMATION6,
745: crl.RULE_INFORMATION10,
746: crl.RULE_INFORMATION11
747: FROM OKC_RULE_GROUPS_B crg,
748: OKC_RULES_B crl,
749: OKL_STRM_TYPE_B stty
750: WHERE stty.id = crl.object1_id1
751: AND stty.stream_type_purpose = pmnt_strm_purpose

Line 8822: okc_rule_groups_b rgp,

8818: rul_slh.object1_id1 strm_type_id1,
8819: rul_slh.object1_id2 strm_type_id2,
8820: cleb.currency_code
8821: FROM okc_rules_b rul,
8822: okc_rule_groups_b rgp,
8823: okc_rules_b rul_slh,
8824: okc_k_lines_b cleb
8825: --Bug# : 3124577 - 11.5.10 : Rule Migration
8826: WHERE rul.rule_information_category = 'LASLL'