2906: end_date_active
2907: INTO
2908: St_Start_Date,
2909: St_End_Date
2910: FROM PA_PROJECT_PLAYERS
2911: WHERE PROJECT_ID = X_Award_Project_Id
2912: and PERSON_ID = X_Person_Id_Old
2913: and PROJECT_ROLE_TYPE = 'PROJECT MANAGER';
2914:
2937: (St_End_Date <> X_End_Date) OR
2938: (St_End_Date IS NULL )
2939: ) THEN
2940: /* Commented out NOCOPY for bug fix 1533504 as this a view now in 11i
2941: UPDATE pa_project_players
2942: set person_id = X_Person_Id_New,
2943: start_date_active = X_Start_Date,
2944: end_date_active = X_End_Date
2945: WHERE