[Home] [Help]
188: ,cplb.id cpl_id
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
326: ,p_chr_id IN okc_k_headers_b.id%TYPE
327: ,p_asset_id IN okc_k_lines_b.id%TYPE
328: ,p_subsidy_id IN okl_subsidies_b.id%TYPE
329: ,p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE
330: ,p_trx_amount IN okl_k_lines.amount%TYPE
331: ) IS
332:
333: -- cursor to fetch asset details
334: CURSOR c_get_asset_csr IS
557: SELECT clet_sub.name subsidy_name,
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,
810: ,cplb.id cpl_id
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
845: ,cplb.id cpl_id
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
881: ,kle.subsidy_id subsidy
882: FROM okc_k_lines_b cleb
883: ,okc_line_styles_b lseb
884: ,okc_k_party_roles_b cplb
885: ,okl_k_lines kle
886: WHERE cleb.dnz_chr_id = p_orig_chr_id
887: AND lseb.id = cleb.lse_id
888: AND lseb.lty_code = 'SUBSIDY'
889: AND cplb.cle_id = cleb.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
933: AND asst_cleb.dnz_chr_id = cleb.dnz_chr_id