APPS.PA_PROJECT_CHECK_PVT dependencies on PA_PROJECT_PLAYERS

Line 2930: FROM pa_project_players

2926: , RESOURCE_TYPE_ID
2927: , RECORD_VERSION_NUMBER
2928: , scheduled_flag
2929: -- end NEW code for ROLE BASED SECURITY
2930: FROM pa_project_players
2931: WHERE project_id = p_project_id
2932: AND project_role_type = 'PROJECT MANAGER'
2933: -- AND nvl(end_date_active,nvl(p_start_date,sysdate)) between nvl(p_start_date,sysdate) and nvl(p_end_date,sysdate);
2934: AND nvl(end_date_active,nvl(p_start_date,sysdate)) between nvl(p_start_date,sysdate) and nvl(p_end_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE); -- Added for Bug 5183218

Line 3049: UPDATE pa_project_players

3045: /*
3046: -- begin OLD code before changes for ROLE BASED SECURITY
3047: IF p_key_members(i).end_date < p_start_date
3048: THEN
3049: UPDATE pa_project_players
3050: SET end_date_active = p_key_members(i).end_date
3051: WHERE project_id = p_project_id
3052: AND person_id = l_current_project_man_rec.person_id
3053: AND project_role_type = 'PROJECT MANAGER';

Line 3055: UPDATE pa_project_players

3051: WHERE project_id = p_project_id
3052: AND person_id = l_current_project_man_rec.person_id
3053: AND project_role_type = 'PROJECT MANAGER';
3054: ELSE
3055: UPDATE pa_project_players
3056: SET end_date_active =
3057: Decode( nvl(p_start_date,
3058: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
3059: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 3133: UPDATE pa_project_players

3129: l_new_end_date := p_start_date - 1;
3130: END IF;
3131: /*
3132: -- begin OLD code before changes for ROLE BASED SECURITY
3133: UPDATE pa_project_players
3134: SET end_date_active =
3135: Decode (SIGN(start_date_active-l_new_end_date),1,
3136: start_date_active, l_new_end_date)
3137: WHERE project_id = p_project_id

Line 3160: From pa_project_players

3156: Select
3157: Decode (SIGN(start_date_active-l_new_end_date),1,
3158: start_date_active, l_new_end_date)
3159: Into v_end_date
3160: From pa_project_players
3161: Where project_id = p_project_id
3162: And person_id = l_current_project_man_rec.person_id
3163: And project_role_type = 'PROJECT MANAGER'; */
3164: