APPS.PA_PROJECT_PUB dependencies on PA_PROJECT_PLAYERS

Line 482: from pa_project_players

478: -- End of Bug fix 4878696
479:
480: CURSOR c_prj_count(c_project_id IN NUMBER ) IS
481: select count(*)
482: from pa_project_players
483: where project_id = c_project_id
484: and project_role_type='PROJECT MANAGER';
485:
486: l_proj_status pa_projects_all.project_status_code%TYPE;

Line 9652: SELECT pa_project_players.* --,rowid /*rowid id commented for bug 1939295 */

9648: CURSOR l_key_member_csr (l_project_id NUMBER,l_person_id NUMBER,
9649: l_role_type VARCHAR2 ,
9650: l_start_date_active DATE)
9651: IS
9652: SELECT pa_project_players.* --,rowid /*rowid id commented for bug 1939295 */
9653: FROM pa_project_players
9654: WHERE project_id = l_project_id
9655: AND person_id = l_person_id
9656: AND project_role_type = l_role_type

Line 9653: FROM pa_project_players

9649: l_role_type VARCHAR2 ,
9650: l_start_date_active DATE)
9651: IS
9652: SELECT pa_project_players.* --,rowid /*rowid id commented for bug 1939295 */
9653: FROM pa_project_players
9654: WHERE project_id = l_project_id
9655: AND person_id = l_person_id
9656: AND project_role_type = l_role_type
9657: AND start_date_active = l_start_date_active;

Line 9691: FROM pa_project_players

9687: IS
9688: SELECT person_id,
9689: start_date_active,
9690: end_date_active
9691: FROM pa_project_players
9692: WHERE project_id = p_project_id
9693: AND project_role_type = 'PROJECT MANAGER'
9694: AND nvl(end_date_active,p_start_date) >= p_start_date;
9695:

Line 10257: from pa_project_players

10253: -- End of Bug fix 4878696
10254:
10255: CURSOR c_prj_count(c_project_id IN NUMBER ) IS
10256: select count(*)
10257: from pa_project_players
10258: where project_id = c_project_id
10259: and project_role_type='PROJECT MANAGER';
10260:
10261: l_proj_status pa_projects_all.project_status_code%TYPE;

Line 18578: UPDATE PA_PROJECT_PLAYERS SET

18574: THEN
18575: if p_multiple_task_msg <> 'F' then
18576: /*
18577: -- begin OLD code before changes for ROLE BASED SECURITY
18578: UPDATE PA_PROJECT_PLAYERS SET
18579: START_DATE_ACTIVE = l_temp_start_date,
18580: END_DATE_ACTIVE = l_temp_end_date
18581: WHERE ROWID = l_key_members_rec.rowid;
18582: -- end OLD code before changes for ROLE BASED SECURITY

Line 18586: -- PA_PROJECT_PLAYERS for the rowid in the cursor

18582: -- end OLD code before changes for ROLE BASED SECURITY
18583: */
18584: -- begin NEW code for ROLE BASED SECURITY
18585: -- updating START_DATE_ACTIVE and END_DATE_ACTIVE of
18586: -- PA_PROJECT_PLAYERS for the rowid in the cursor
18587: SELECT COMPLETION_DATE
18588: INTO v_completion_date
18589: FROM pa_projects p
18590: WHERE p.project_id = l_key_members_rec.project_id;