APPS.PA_PROJECT_PARTIES_UTILS dependencies on PA_PROJECT_PLAYERS

Line 983: l_person_id pa_project_players.person_id%TYPE;

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

Line 985: l_start_date pa_project_players.start_date_active%TYPE;

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

Line 986: l_end_date pa_project_players.end_date_active%TYPE;

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

Line 987: l_end_date_old pa_project_players.end_date_active%TYPE;

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

Line 1011: from pa_project_players

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

Line 1043: from pa_project_players

1039: CURSOR c_project_players IS
1040: select person_id
1041: ,trunc(start_date_active)
1042: ,trunc(end_date_active)
1043: from pa_project_players
1044: where project_id = p_project_id
1045: and project_role_type='PROJECT MANAGER'
1046: AND NOT (
1047: exists(