APPS.PA_PROJECT_PARTIES_UTILS dependencies on PA_PROJECT_PLAYERS

Line 980: l_person_id pa_project_players.person_id%TYPE;

976: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;
977: l_proj_type pa_project_types_all.project_type%TYPE; -- Added for bug#5098966
978: l_proj_start_date pa_projects_all.start_date%TYPE;
979: l_proj_end_date pa_projects_all.completion_date%TYPE;
980: l_person_id pa_project_players.person_id%TYPE;
981: l_party_id pa_project_parties.project_party_id%TYPE;
982: l_start_date pa_project_players.start_date_active%TYPE;
983: l_end_date pa_project_players.end_date_active%TYPE;
984: l_end_date_old pa_project_players.end_date_active%TYPE;

Line 982: l_start_date pa_project_players.start_date_active%TYPE;

978: l_proj_start_date pa_projects_all.start_date%TYPE;
979: l_proj_end_date pa_projects_all.completion_date%TYPE;
980: l_person_id pa_project_players.person_id%TYPE;
981: l_party_id pa_project_parties.project_party_id%TYPE;
982: l_start_date pa_project_players.start_date_active%TYPE;
983: l_end_date pa_project_players.end_date_active%TYPE;
984: l_end_date_old pa_project_players.end_date_active%TYPE;
985:
986: /* Changing the query to base table to improve performance instead of pa_projects_v view. Bug no. 4940945*/

Line 983: l_end_date pa_project_players.end_date_active%TYPE;

979: l_proj_end_date pa_projects_all.completion_date%TYPE;
980: l_person_id pa_project_players.person_id%TYPE;
981: l_party_id pa_project_parties.project_party_id%TYPE;
982: l_start_date pa_project_players.start_date_active%TYPE;
983: l_end_date pa_project_players.end_date_active%TYPE;
984: l_end_date_old pa_project_players.end_date_active%TYPE;
985:
986: /* Changing the query to base table to improve performance instead of pa_projects_v view. Bug no. 4940945*/
987: CURSOR c_prj IS

Line 984: l_end_date_old pa_project_players.end_date_active%TYPE;

980: l_person_id pa_project_players.person_id%TYPE;
981: l_party_id pa_project_parties.project_party_id%TYPE;
982: l_start_date pa_project_players.start_date_active%TYPE;
983: l_end_date pa_project_players.end_date_active%TYPE;
984: l_end_date_old pa_project_players.end_date_active%TYPE;
985:
986: /* Changing the query to base table to improve performance instead of pa_projects_v view. Bug no. 4940945*/
987: CURSOR c_prj IS
988: select ps.project_system_status_code

Line 1008: from pa_project_players

1004: CURSOR c_project_players IS
1005: select person_id
1006: ,start_date_active
1007: ,end_date_active
1008: from pa_project_players
1009: where project_id = p_project_id
1010: and project_role_type='PROJECT MANAGER'
1011: order by start_date_active;
1012:

Line 1040: from pa_project_players

1036: CURSOR c_project_players IS
1037: select person_id
1038: ,start_date_active
1039: ,end_date_active
1040: from pa_project_players
1041: where project_id = p_project_id
1042: and project_role_type='PROJECT MANAGER'
1043: AND NOT (
1044: exists(