APPS.OKL_AM_TERMINATE_INV_AGMT_PVT dependencies on OKL_STREAMS

Line 538: FROM OKL_STREAMS STM,

534: CURSOR check_ia_sel_date_csr( p_ia_id IN NUMBER) IS
535: SELECT 1 id
536: FROM DUAL WHERE EXISTS (
537: SELECT SEL.id
538: FROM OKL_STREAMS STM,
539: OKL_STRM_ELEMENTS SEL,
540: OKL_STRM_TYPE_B STY,
541: OKL_POOLS POL,
542: OKL_POOL_CONTENTS POC,

Line 691: FROM OKL_STREAMS STM,

687: CURSOR get_unbilled_sel_csr( p_ia_id IN NUMBER) IS
688: SELECT 1 id
689: FROM DUAL WHERE EXISTS (
690: SELECT SEL.id
691: FROM OKL_STREAMS STM,
692: OKL_STRM_ELEMENTS SEL,
693: OKL_STRM_TYPE_B STY,
694: OKL_POOLS POL,
695: OKL_POOL_CONTENTS POC,

Line 859: okl_streams stm,

855: SELECT
856: ste.id sel_id
857: FROM
858: okl_strm_elements ste,
859: okl_streams stm,
860: okl_strm_type_v sty
861: WHERE ste.amount <> 0
862: AND stm.id = ste.stm_id
863: AND sty.stream_type_subclass IS NULL

Line 882: okl_streams stm,

878: SELECT
879: ste.id sel_id
880: FROM
881: okl_strm_elements ste,
882: okl_streams stm,
883: okl_strm_type_v sty
884: WHERE ste.amount <> 0
885: AND stm.id = ste.stm_id
886: AND sty.stream_type_subclass = 'INVESTOR_DISBURSEMENT'

Line 929: /* OKL_STREAMS_UTIL.get_dependent_stream_type(p_ia_rec.id,

925:
926: SAVEPOINT check_pending_disb_trx;
927:
928: -- smoduga +++++++++ User Defined Streams -- start ++++++++++++++++
929: /* OKL_STREAMS_UTIL.get_dependent_stream_type(p_ia_rec.id,
930: 'RENT',
931: 'INVESTOR_RENT_DISBURSEMENT_BASIS',
932: l_return_status,
933: lx_invdisbas_sty_id);

Line 935: OKL_STREAMS_UTIL.get_dependent_stream_type(p_ia_rec.id,

931: 'INVESTOR_RENT_DISBURSEMENT_BASIS',
932: l_return_status,
933: lx_invdisbas_sty_id);
934:
935: OKL_STREAMS_UTIL.get_dependent_stream_type(p_ia_rec.id,
936: 'RENT',
937: 'INVESTOR_RENT_PAYABLE',
938: l_return_status,
939: lx_invpbl_sty_id);

Line 943: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_rec.id,

939: lx_invpbl_sty_id);
940: -- smoduga +++++++++ User Defined Streams -- end ++++++++++++++++ */
941:
942: -- gkadarka fix for bug 4609338 - start
943: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_rec.id,
944: 'INVESTOR_RENT_DISB_BASIS',-- 'INVESTOR_RENT_DISBURSEMENT_BASIS', --GKADARKA CHANGED FOR TEST
945: l_return_status,
946: lx_invdisbas_sty_id);
947:

Line 948: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_rec.id,

944: 'INVESTOR_RENT_DISB_BASIS',-- 'INVESTOR_RENT_DISBURSEMENT_BASIS', --GKADARKA CHANGED FOR TEST
945: l_return_status,
946: lx_invdisbas_sty_id);
947:
948: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_rec.id,
949: 'INVESTOR_RENT_PAYABLE',
950: l_return_status,
951: lx_invpbl_sty_id);
952: /*Sosharma

Line 956: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_rec.id,

952: /*Sosharma
953: 14-01-2008
954: Changes to included loan type of contracts in Investor Agreement
955: Start Changes*/
956: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_rec.id,
957: 'INVESTOR_PRINCIPAL_DISB_BASIS',-- 'INVESTOR_LOAN_DISBURSEMENT_BASIS', --GKADARKA CHANGED FOR TEST
958: l_return_status,
959: lx_prindisbas_sty_id);
960:

Line 961: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_rec.id,

957: 'INVESTOR_PRINCIPAL_DISB_BASIS',-- 'INVESTOR_LOAN_DISBURSEMENT_BASIS', --GKADARKA CHANGED FOR TEST
958: l_return_status,
959: lx_prindisbas_sty_id);
960:
961: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_rec.id,
962: 'INVESTOR_INTEREST_DISB_BASIS',-- 'INVESTOR_LOAN_DISBURSEMENT_BASIS', --GKADARKA CHANGED FOR TEST
963: l_return_status,
964: lx_intdisbas_sty_id);
965:

Line 967: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_rec.id,

963: l_return_status,
964: lx_intdisbas_sty_id);
965:
966:
967: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_rec.id,
968: 'INVESTOR_PRINCIPAL_PAYABLE',
969: l_return_status,
970: lx_prinpbl_sty_id);
971:

Line 972: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_rec.id,

968: 'INVESTOR_PRINCIPAL_PAYABLE',
969: l_return_status,
970: lx_prinpbl_sty_id);
971:
972: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_rec.id,
973: 'INVESTOR_INTEREST_PAYABLE',
974: l_return_status,
975: lx_intpbl_sty_id);
976:

Line 980: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_rec.id,

976:
977:
978: -- Principal Paydown streams
979:
980: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_rec.id,
981: 'INVESTOR_PPD_DISB_BASIS',
982: l_return_status,
983: lx_ppddisbas_sty_id);
984: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_rec.id,

Line 984: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_rec.id,

980: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_rec.id,
981: 'INVESTOR_PPD_DISB_BASIS',
982: l_return_status,
983: lx_ppddisbas_sty_id);
984: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_rec.id,
985: 'INVESTOR_PAYDOWN_PAYABLE',
986: l_return_status,
987: lx_ppdpbl_sty_id);
988: