DBA Data[Home] [Help]

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 465: l_resource_list_name pa_resource_lists.name%TYPE;

461: l_total_raw_cost NUMBER;
462: l_total_burdened_cost NUMBER;
463: l_total_revenue NUMBER;
464: l_resource_list_id NUMBER;
465: l_resource_list_name pa_resource_lists.name%TYPE;
466: l_resource_list_description pa_resource_lists.description%TYPE;
467: l_budget_type pa_fin_plan_types_tl.name%TYPE; --Bug 6974760 pa_budget_types.budget_type%TYPE;
468: l_wf_started_date DATE;
469:

Line 466: l_resource_list_description pa_resource_lists.description%TYPE;

462: l_total_burdened_cost NUMBER;
463: l_total_revenue NUMBER;
464: l_resource_list_id NUMBER;
465: l_resource_list_name pa_resource_lists.name%TYPE;
466: l_resource_list_description pa_resource_lists.description%TYPE;
467: l_budget_type pa_fin_plan_types_tl.name%TYPE; --Bug 6974760 pa_budget_types.budget_type%TYPE;
468: l_wf_started_date DATE;
469:
470: l_workflow_started_by_id NUMBER;