[Home] [Help]
1309: --cursor to check financial product
1310: cursor l_pdt_csr (p_subsidy_id in number,
1311: p_asset_cle_id in number) is
1312: select 'Y'
1313: from okl_k_headers khr,
1314: okc_k_lines_b cleb,
1315: okl_subsidy_criteria suc
1316: Where khr.id = cleb.chr_id
1317: And SUC.subsidy_id = p_subsidy_id
1860: --cursor to check financial product
1861: cursor l_pdt_csr (p_subsidy_id in number,
1862: p_chr_id in number) is
1863: select 'Y'
1864: from okl_k_headers khr,
1865: okl_subsidy_criteria suc
1866: Where khr.id = p_chr_id
1867: And SUC.subsidy_id = p_subsidy_id
1868: And SUC.product_id = khr.pdt_id
2389: --cursor to check financial product
2390: /* cursor l_pdt_csr (p_subsidy_id in number,
2391: p_chr_id in number) is
2392: select 'Y'
2393: from okl_k_headers khr,
2394: okl_subsidy_criteria suc
2395: Where khr.id = p_chr_id
2396: And SUC.subsidy_id = p_subsidy_id
2397: And SUC.product_id = khr.pdt_id