[Home] [Help]
189: ,kle.sty_id sty_id
190: ,cleb.cle_id asset_id
191: ,cleb.currency_code
192: FROM okl_k_lines kle
193: ,okc_k_lines_tl clet
194: ,okc_k_lines_b cleb
195: ,okc_statuses_b stsb
196: ,okc_line_styles_b lseb
197: ,okc_k_party_roles_b cplb
558: clet_asst.name asset_number,
559: subb.id subsidy_id
560: FROM okl_subsidies_b subb,
561: okl_k_lines kle_sub,
562: okc_k_lines_tl clet_sub,
563: okc_k_lines_b cleb_sub,
564: okc_line_styles_b lseb_sub,
565: okc_k_lines_tl clet_asst,
566: okc_k_lines_b cleb_asst,
561: okl_k_lines kle_sub,
562: okc_k_lines_tl clet_sub,
563: okc_k_lines_b cleb_sub,
564: okc_line_styles_b lseb_sub,
565: okc_k_lines_tl clet_asst,
566: okc_k_lines_b cleb_asst,
567: okc_line_styles_b lseb_asst
568: WHERE subb.id = kle_sub.subsidy_id
569: AND kle_sub.id = cleb_sub.id
583: AND cleb_asst.sts_code <> 'ABANDONED';
584:
585: -- cursor to fetch the pool transaction records with REDUCTION operation, created when the contract was booked
586: CURSOR c_sub_pool_trx_csr (cp_chr_id IN okc_k_headers_b.id%TYPE
587: ,cp_asset_number IN okc_k_lines_tl.name%TYPE
588: ,cp_subsidy_id IN okl_subsidies_b.id%TYPE
589: ,cp_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE
590: ) IS
591: SELECT source_type_code
811: ,kle.sty_id sty_id
812: ,cleb.cle_id asset_id
813: ,cleb.currency_code
814: FROM okl_k_lines kle
815: ,okc_k_lines_tl clet
816: ,okc_k_lines_b cleb
817: ,okc_statuses_b stsb
818: ,okc_line_styles_b lseb
819: ,okc_k_party_roles_b cplb
846: ,kle.sty_id sty_id
847: ,cleb.cle_id asset_id
848: ,cleb.currency_code
849: FROM okl_k_lines kle
850: ,okc_k_lines_tl clet
851: ,okc_k_lines_b cleb
852: ,okc_statuses_b stsb
853: ,okc_line_styles_b lseb
854: ,okc_k_party_roles_b cplb
924: ,asst_cleb.orig_system_id1 orig_asst_cle_id
925: FROM okc_k_lines_b asst_cleb
926: ,okc_statuses_b asst_sts
927: ,okc_k_party_roles_b cplb
928: ,okc_k_lines_tl clet
929: ,okl_k_lines kle
930: ,okc_line_styles_b lseb
931: ,okc_k_lines_b cleb
932: WHERE asst_cleb.id = cleb.cle_id