APPS.OKL_SPLIT_ASSET_PVT dependencies on OKL_STRM_TYPE_B

Line 715: OKL_STRM_TYPE_B stty

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'
718: AND crl.rgp_id = crg.id
719: AND crg.RGD_CODE = 'LALEVL'

Line 727: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,

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,
730: crl.id,
731: crl.object1_id1,

Line 742: OKL_STRM_TYPE_B stty

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
745: AND crl.rgp_id = crg.id
746: AND crg.RGD_CODE = rgcode

Line 7920: okl_strm_type_b sty

7916: sty.stream_type_purpose,
7917: --Bug# 6344223
7918: str.link_hist_stream_id
7919: FROM okl_streams str,
7920: okl_strm_type_b sty
7921: WHERE
7922: str.kle_id = kleId
7923: AND str.say_code = status
7924: AND str.sty_id = sty.id;