DBA Data[Home] [Help]

APPS.GMS_MULTI_FUNDING dependencies on PA_PROJECT_PLAYERS

Line 2910: FROM PA_PROJECT_PLAYERS

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:

Line 2941: UPDATE pa_project_players

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