APPS.GMS_CLIENT_EXTN_BUDGET_WF dependencies on PA_RESOURCE_LISTS

Line 293: FROM pa_resource_lists

289: CURSOR l_resource_list_csr( p_resource_list_id NUMBER )
290: IS
291: SELECT name
292: , description
293: FROM pa_resource_lists
294: WHERE resource_list_id = p_resource_list_id;
295: --
296: CURSOR l_budget_type_csr( p_budget_type_code VARCHAR2 )
297: IS

Line 346: l_resource_list_name pa_resource_lists.name%TYPE;

342: l_total_raw_cost NUMBER;
343: l_total_burdened_cost NUMBER;
344: l_total_revenue NUMBER;
345: l_resource_list_id NUMBER;
346: l_resource_list_name pa_resource_lists.name%TYPE;
347: l_resource_list_description pa_resource_lists.description%TYPE;
348: l_budget_type pa_budget_types.budget_type%TYPE;
349: l_wf_started_date DATE;
350:

Line 347: l_resource_list_description pa_resource_lists.description%TYPE;

343: l_total_burdened_cost NUMBER;
344: l_total_revenue NUMBER;
345: l_resource_list_id NUMBER;
346: l_resource_list_name pa_resource_lists.name%TYPE;
347: l_resource_list_description pa_resource_lists.description%TYPE;
348: l_budget_type pa_budget_types.budget_type%TYPE;
349: l_wf_started_date DATE;
350:
351: l_workflow_started_by_id NUMBER;

Line 1031: FROM pa_resource_lists

1027: CURSOR l_resource_list_csr( p_resource_list_id NUMBER )
1028: IS
1029: SELECT name
1030: , description
1031: FROM pa_resource_lists
1032: WHERE resource_list_id = p_resource_list_id;
1033: --
1034: CURSOR l_budget_type_csr( p_budget_type_code VARCHAR2 )
1035: IS

Line 1084: l_resource_list_name pa_resource_lists.name%TYPE;

1080: l_total_raw_cost NUMBER;
1081: l_total_burdened_cost NUMBER;
1082: l_total_revenue NUMBER;
1083: l_resource_list_id NUMBER;
1084: l_resource_list_name pa_resource_lists.name%TYPE;
1085: l_resource_list_description pa_resource_lists.description%TYPE;
1086: l_budget_type pa_budget_types.budget_type%TYPE;
1087: l_wf_started_date DATE;
1088:

Line 1085: l_resource_list_description pa_resource_lists.description%TYPE;

1081: l_total_burdened_cost NUMBER;
1082: l_total_revenue NUMBER;
1083: l_resource_list_id NUMBER;
1084: l_resource_list_name pa_resource_lists.name%TYPE;
1085: l_resource_list_description pa_resource_lists.description%TYPE;
1086: l_budget_type pa_budget_types.budget_type%TYPE;
1087: l_wf_started_date DATE;
1088:
1089: l_workflow_started_by_id NUMBER;