APPS.PA_CLIENT_EXTN_BUDGET_WF dependencies on PA_RESOURCE_LISTS

Line 377: FROM pa_resource_lists

373: CURSOR l_resource_list_csr( p_resource_list_id NUMBER )
374: IS
375: SELECT name
376: , description
377: FROM pa_resource_lists
378: WHERE resource_list_id = p_resource_list_id;
379: --
380: CURSOR l_budget_type_csr( p_budget_type_code VARCHAR2 )
381: IS

Line 458: l_resource_list_name pa_resource_lists.name%TYPE;

454: l_total_raw_cost NUMBER;
455: l_total_burdened_cost NUMBER;
456: l_total_revenue NUMBER;
457: l_resource_list_id NUMBER;
458: l_resource_list_name pa_resource_lists.name%TYPE;
459: l_resource_list_description pa_resource_lists.description%TYPE;
460: l_budget_type pa_fin_plan_types_tl.name%TYPE; --Bug 6974760 pa_budget_types.budget_type%TYPE;
461: l_wf_started_date DATE;
462:

Line 459: l_resource_list_description pa_resource_lists.description%TYPE;

455: l_total_burdened_cost NUMBER;
456: l_total_revenue NUMBER;
457: l_resource_list_id NUMBER;
458: l_resource_list_name pa_resource_lists.name%TYPE;
459: l_resource_list_description pa_resource_lists.description%TYPE;
460: l_budget_type pa_fin_plan_types_tl.name%TYPE; --Bug 6974760 pa_budget_types.budget_type%TYPE;
461: l_wf_started_date DATE;
462:
463: l_workflow_started_by_id NUMBER;