APPS.PA_RES_LIST_ASSIGNMENTS dependencies on PA_RESOURCE_LISTS

Line 20: Select End_Date_Active from PA_RESOURCE_LISTS

16: Cursor Proj_Cur is
17: Select Project_Id from Pa_Projects_all -- changed for bug 6743458
18: where Project_id = X_Project_Id;
19: Cursor Res_List_Cur is
20: Select End_Date_Active from PA_RESOURCE_LISTS
21: where Resource_list_Id = X_Resource_List_id;
22: Begin
23: X_Resource_list_Assgmt_id := 0;
24: W_User_id := To_Number(FND_PROFILE.VALUE('USER_ID'));

Line 40: x_err_stage := 'Select End_date_Active from Pa_Resource_lists '||

36: Close Proj_Cur;
37: Return;
38: End If;
39: Close Proj_Cur;
40: x_err_stage := 'Select End_date_Active from Pa_Resource_lists '||
41: To_Char(X_resource_list_id);
42: Open Res_List_Cur;
43: Fetch Res_List_Cur into W_End_Date;
44: If Res_list_Cur%NOTFOUND Then