DBA Data[Home] [Help]

APPS.PA_PROJECT_PVT dependencies on PA_PROJECT_PLAYERS

Line 117: from pa_project_players

113: p_start_date DATE,
114: p_end_date DATE
115: ) IS
116: select count(*)
117: from pa_project_players
118: where project_id = p_project_id
119: and project_role_type = 'PROJECT MANAGER'
120: and (( nvl(end_date_active,nvl(p_start_date,sysdate)) between
121: nvl(p_start_date,sysdate) and nvl(p_end_date,sysdate))

Line 351: INSERT INTO pa_project_players

347: ELSE
348:
349: /*
350: -- begin OLD code before changes for ROLE BASED SECURITY
351: INSERT INTO pa_project_players
352: (project_id
353: ,person_id
354: ,project_role_type
355: ,start_date_active