APPS.OKL_SPLIT_ASSET_PVT dependencies on OKC_RULE_GROUPS_B

Line 713: FROM OKC_RULE_GROUPS_B crg,

709: CURSOR l_pmnt_strm_check(p_chrId NUMBER,
710: p_cle_id NUMBER
711: ) IS
712: SELECT crl.id
713: FROM OKC_RULE_GROUPS_B crg,
714: OKC_RULES_B crl,
715: OKL_STRM_TYPE_B stty
716: WHERE stty.id = crl.object1_id1
717: AND stty.stream_type_purpose = 'PRINCIPAL_PAYMENT'

Line 725: rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

721: AND crg.dnz_chr_id = p_chrId
722: and cle_id = p_cle_id;
723:
724: CURSOR l_pmnt_strm_check2(
725: rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
726: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
727: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,
728: chrId NUMBER) IS
729: SELECT crg.cle_id,

Line 740: FROM OKC_RULE_GROUPS_B crg,

736: crl.RULE_INFORMATION5,
737: crl.RULE_INFORMATION6,
738: crl.RULE_INFORMATION10,
739: crl.RULE_INFORMATION11
740: FROM OKC_RULE_GROUPS_B crg,
741: OKC_RULES_B crl,
742: OKL_STRM_TYPE_B stty
743: WHERE stty.id = crl.object1_id1
744: AND stty.stream_type_purpose = pmnt_strm_purpose

Line 8769: okc_rule_groups_b rgp,

8765: rul_slh.object1_id1 strm_type_id1,
8766: rul_slh.object1_id2 strm_type_id2,
8767: cleb.currency_code
8768: FROM okc_rules_b rul,
8769: okc_rule_groups_b rgp,
8770: okc_rules_b rul_slh,
8771: okc_k_lines_b cleb
8772: --Bug# : 3124577 - 11.5.10 : Rule Migration
8773: WHERE rul.rule_information_category = 'LASLL'