APPS.PA_PROJECT_PUB dependencies on PA_PROJECT_PLAYERS

Line 483: from pa_project_players

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

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

9900: CURSOR l_key_member_csr (l_project_id NUMBER,l_person_id NUMBER,
9901: l_role_type VARCHAR2 ,
9902: l_start_date_active DATE)
9903: IS
9904: SELECT pa_project_players.* --,rowid /*rowid id commented for bug 1939295 */
9905: FROM pa_project_players
9906: WHERE project_id = l_project_id
9907: AND person_id = l_person_id
9908: AND project_role_type = l_role_type

Line 9905: FROM pa_project_players

9901: l_role_type VARCHAR2 ,
9902: l_start_date_active DATE)
9903: IS
9904: SELECT pa_project_players.* --,rowid /*rowid id commented for bug 1939295 */
9905: FROM pa_project_players
9906: WHERE project_id = l_project_id
9907: AND person_id = l_person_id
9908: AND project_role_type = l_role_type
9909: AND start_date_active = l_start_date_active;

Line 9943: FROM pa_project_players

9939: IS
9940: SELECT person_id,
9941: start_date_active,
9942: end_date_active
9943: FROM pa_project_players
9944: WHERE project_id = p_project_id
9945: AND project_role_type = 'PROJECT MANAGER'
9946: AND nvl(end_date_active,p_start_date) >= p_start_date;
9947:

Line 10519: from pa_project_players

10515: -- End of Bug fix 4878696
10516:
10517: CURSOR c_prj_count(c_project_id IN NUMBER ) IS
10518: select count(*)
10519: from pa_project_players
10520: where project_id = c_project_id
10521: and project_role_type='PROJECT MANAGER';
10522:
10523: l_proj_status pa_projects_all.project_status_code%TYPE;

Line 18976: UPDATE PA_PROJECT_PLAYERS SET

18972: THEN
18973: if p_multiple_task_msg <> 'F' then
18974: /*
18975: -- begin OLD code before changes for ROLE BASED SECURITY
18976: UPDATE PA_PROJECT_PLAYERS SET
18977: START_DATE_ACTIVE = l_temp_start_date,
18978: END_DATE_ACTIVE = l_temp_end_date
18979: WHERE ROWID = l_key_members_rec.rowid;
18980: -- end OLD code before changes for ROLE BASED SECURITY

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

18980: -- end OLD code before changes for ROLE BASED SECURITY
18981: */
18982: -- begin NEW code for ROLE BASED SECURITY
18983: -- updating START_DATE_ACTIVE and END_DATE_ACTIVE of
18984: -- PA_PROJECT_PLAYERS for the rowid in the cursor
18985: SELECT COMPLETION_DATE
18986: INTO v_completion_date
18987: FROM pa_projects p
18988: WHERE p.project_id = l_key_members_rec.project_id;