264: INTO l_resource_list_id
265: FROM pa_resource_list_members
266: WHERE resource_list_member_id = p_resource_list_member_id;
267:
268: UPDATE PA_RESOURCE_LISTS_ALL_BG
269: SET default_expenditure_type = p_expenditure_type_2 ,
270: last_update_date = sysdate
271: WHERE resource_list_id =l_resource_list_id;
272: END IF;
444: INTO l_resource_list_id
445: FROM pa_resource_list_members
446: WHERE resource_list_member_id = p_resource_list_member_id;
447:
448: UPDATE PA_RESOURCE_LISTS_ALL_BG
449: SET default_expenditure_type = p_expenditure_type_2 ,
450: last_update_date = sysdate
451: WHERE resource_list_id =l_resource_list_id;
452: END IF;