APPS.OKL_SUBSIDY_POOL_AUTH_TRX_PVT dependencies on OKL_SUBSIDIES_B

Line 328: ,p_subsidy_id IN okl_subsidies_b.id%TYPE

324: ,x_msg_count OUT NOCOPY NUMBER
325: ,x_msg_data OUT NOCOPY VARCHAR2
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:

Line 560: FROM okl_subsidies_b subb,

556: CURSOR c_subsidy_csr(cp_chr_id IN okc_k_headers_b.id%TYPE) 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,

Line 588: ,cp_subsidy_id IN okl_subsidies_b.id%TYPE

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
592: ,source_object_id