APPS.OKL_SUBSIDY_POOL_WF dependencies on OKL_SUBSIDY_POOLS_V

Line 123: lv_pool_description okl_subsidy_pools_v.short_description%TYPE;

119: lv_total_budget VARCHAR2(200);
120: lv_currency_code okl_subsidy_pools_b.currency_code%TYPE;
121: lv_from_date okl_subsidy_pools_b.effective_from_date%TYPE;
122: lv_to_date okl_subsidy_pools_b.effective_to_date%TYPE;
123: lv_pool_description okl_subsidy_pools_v.short_description%TYPE;
124: lv_requestor VARCHAR2(100);
125: lv_message_body VARCHAR2(4000);
126: BEGIN
127: lv_pool_name := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 897: lv_pool_description okl_subsidy_pools_v.short_description%TYPE;

893: lv_total_budget VARCHAR2(200);
894: lv_currency_code okl_subsidy_pools_b.currency_code%TYPE;
895: lv_from_date okl_subsidy_pools_b.effective_from_date%TYPE;
896: lv_to_date okl_subsidy_pools_b.effective_to_date%TYPE;
897: lv_pool_description okl_subsidy_pools_v.short_description%TYPE;
898: lv_requestor VARCHAR2(100);
899: lv_budget_type fnd_lookups.meaning%TYPE;
900:
901: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_WF.GET_SUBSIDY_POOL_APPROVER';

Line 1034: lv_pool_description okl_subsidy_pools_v.short_description%TYPE;

1030: lv_total_budget VARCHAR2(200);
1031: lv_currency_code okl_subsidy_pools_b.currency_code%TYPE;
1032: lv_from_date okl_subsidy_pools_b.effective_from_date%TYPE;
1033: lv_to_date okl_subsidy_pools_b.effective_to_date%TYPE;
1034: lv_pool_description okl_subsidy_pools_v.short_description%TYPE;
1035: lv_approver VARCHAR2(100);
1036: lv_budget_type fnd_lookups.meaning%TYPE;
1037: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'set_msg_attributes';
1038:

Line 1297: FROM okl_subsidy_pools_v pool

1293: ,pool.total_budgets
1294: ,pool.currency_code
1295: ,pool.short_description
1296: ,bud.budget_amount
1297: FROM okl_subsidy_pools_v pool
1298: ,okl_subsidy_pool_budgets_b bud
1299: WHERE pool.id = cp_subsidy_pool_id
1300: AND pool.id = bud.subsidy_pool_id;
1301: cv_get_pool_info c_get_pool_info_csr%ROWTYPE;