DBA Data[Home] [Help]

APPS.PA_RES_LIST_ASSIGNMENTS dependencies on PA_RESOURCE_LIST_USE_CODES_V

Line 153: Select Budget_Type_Yn from PA_RESOURCE_LIST_USE_CODES_V where

149: Select Project_id,Resource_list_Id from
150: PA_RESOURCE_LIST_ASSIGNMENTS
151: Where Resource_list_Assignment_Id = X_Resource_list_Assgmt_id;
152: Cursor Res_List_Use_Code_Cur is
153: Select Budget_Type_Yn from PA_RESOURCE_LIST_USE_CODES_V where
154: List_Use_Code = X_Use_Code;
155: Cursor Res_list_uses_cur is
156: Select Row_id,Resource_List_Id
157: from Pa_Resource_list_uses_v where Project_id = X_Project_id and

Line 179: ' PA_RESOURCE_LIST_USE_CODES_V '||

175: Return;
176: End If;
177: Close Res_List_Asgmt_Cur;
178: x_err_stage := 'Select Budget_Type_Yn from '||
179: ' PA_RESOURCE_LIST_USE_CODES_V '||
180: To_Char(W_Asgmt_Res_list_id);
181: Open Res_List_Use_Code_Cur;
182: Fetch Res_List_Use_Code_Cur into W_Budget_type_yn;
183: If Res_List_Use_Code_Cur%NOTFOUND Then