APPS.OKL_SUBSIDY_POOL_APPROVAL_PVT dependencies on OKL_SUBSIDY_POOL_BUDGETS_B

Line 39: FROM okl_subsidy_pool_budgets_b

35: cv_pool_details_csr c_get_pool_details_csr%ROWTYPE;
36:
37: CURSOR c_get_pool_line_number IS
38: SELECT count(*) number_of_lines
39: FROM okl_subsidy_pool_budgets_b
40: WHERE subsidy_pool_id = p_subsidy_pool_id;
41: lv_number_of_lines NUMBER;
42:
43: CURSOR c_get_pool_line_details_csr IS

Line 48: FROM okl_subsidy_pool_budgets_b

44: SELECT id
45: ,budget_type_code
46: ,decision_status_code
47: ,budget_amount
48: FROM okl_subsidy_pool_budgets_b
49: WHERE subsidy_pool_id = p_subsidy_pool_id;
50: cv_get_pool_line_details_csr c_get_pool_line_details_csr%ROWTYPE;
51:
52: CURSOR c_chk_subsidy_assoc_csr IS

Line 363: ,p_subsidy_pool_budget_id IN okl_subsidy_pool_budgets_b.id%TYPE

359: ,p_init_msg_list IN VARCHAR2
360: ,x_return_status OUT NOCOPY VARCHAR2
361: ,x_msg_count OUT NOCOPY NUMBER
362: ,x_msg_data OUT NOCOPY VARCHAR2
363: ,p_subsidy_pool_budget_id IN okl_subsidy_pool_budgets_b.id%TYPE
364: ,x_pool_budget_status OUT NOCOPY okl_subsidy_pool_budgets_b.decision_status_code%TYPE) IS
365: CURSOR c_get_pool_info_csr IS
366: SELECT pool.subsidy_pool_name
367: ,pool.decision_status_code pool_status

Line 364: ,x_pool_budget_status OUT NOCOPY okl_subsidy_pool_budgets_b.decision_status_code%TYPE) IS

360: ,x_return_status OUT NOCOPY VARCHAR2
361: ,x_msg_count OUT NOCOPY NUMBER
362: ,x_msg_data OUT NOCOPY VARCHAR2
363: ,p_subsidy_pool_budget_id IN okl_subsidy_pool_budgets_b.id%TYPE
364: ,x_pool_budget_status OUT NOCOPY okl_subsidy_pool_budgets_b.decision_status_code%TYPE) IS
365: CURSOR c_get_pool_info_csr IS
366: SELECT pool.subsidy_pool_name
367: ,pool.decision_status_code pool_status
368: ,pool.effective_from_date pool_start_date

Line 377: ,okl_subsidy_pool_budgets_b line

373: ,line.budget_type_code
374: ,line.decision_status_code line_status
375: ,line.id budget_line_id
376: FROM okl_subsidy_pools_b pool
377: ,okl_subsidy_pool_budgets_b line
378: WHERE pool.id = line.subsidy_pool_id
379: AND line.id = p_subsidy_pool_budget_id;
380: cv_get_pool_info c_get_pool_info_csr%ROWTYPE;
381:

Line 384: l_budget_status okl_subsidy_pool_budgets_b.decision_status_code%TYPE;

380: cv_get_pool_info c_get_pool_info_csr%ROWTYPE;
381:
382: l_approval_process VARCHAR2(30);
383:
384: l_budget_status okl_subsidy_pool_budgets_b.decision_status_code%TYPE;
385: lv_calc_total_budget okl_subsidy_pools_b.total_budgets%TYPE;
386:
387: l_api_version CONSTANT NUMBER DEFAULT 1.0;
388: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SUBMIT_BUDGET_APPROVAL';