APPS.OKL_SPLIT_ASSET_PVT dependencies on OKL_STRM_TYPE_B

Line 722: OKL_STRM_TYPE_B stty

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

Line 734: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,

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,
737: crl.id,
738: crl.object1_id1,

Line 749: OKL_STRM_TYPE_B stty

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

Line 7973: okl_strm_type_b sty

7969: sty.stream_type_purpose,
7970: --Bug# 6344223
7971: str.link_hist_stream_id
7972: FROM okl_streams str,
7973: okl_strm_type_b sty
7974: WHERE
7975: str.kle_id = kleId
7976: AND str.say_code = status
7977: AND str.sty_id = sty.id;