APPS.PA_RES_LIST_ASSIGNMENTS dependencies on PA_RESOURCE_LIST_USES_V

Line 157: from Pa_Resource_list_uses_v where Project_id = X_Project_id and

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
158: Use_Code = X_Use_Code ;
159:
160: Begin
161: W_User_id := To_Number(FND_PROFILE.VALUE('USER_ID'));

Line 243: Select Resource_list_Assignment_Id from PA_RESOURCE_LIST_USES_V

239:
240: W_Assgmt_Id Number := 0;
241: Old_stack varchar2(630);
242: Cursor Res_List_Asgmt_Cur is
243: Select Resource_list_Assignment_Id from PA_RESOURCE_LIST_USES_V
244: where Resource_list_Assignment_id = X_Resource_list_Assgmt_id;
245:
246: Begin
247: X_err_code := 0;

Line 260: ' Select Resource_list_Assignment_Id from PA_RESOURCE_LIST_USES_V '

256: x_err_code := 10;
257: Return;
258: End If;
259: x_err_stage :=
260: ' Select Resource_list_Assignment_Id from PA_RESOURCE_LIST_USES_V '
261: || To_Char(X_Resource_list_Assgmt_id);
262: Open Res_List_Asgmt_Cur;
263: Fetch Res_List_Asgmt_Cur into W_Assgmt_Id;
264: If Res_List_Asgmt_Cur%NOTFOUND Then