APPS.PA_ASSIGNMENTS_PUB dependencies on PA_PROJECT_SUBTEAM_PARTIES

Line 3118: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM

3114: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
3115: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
3116: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
3117: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
3118: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
3119: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
3120: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
3121: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
3122: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM

Line 3432: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM

3428: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
3429: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
3430: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
3431: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
3432: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
3433: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
3434: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
3435: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
3436: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

Line 6292: pa_project_subteam_parties ppsp

6288:
6289: CURSOR get_asgn_info(l_asmt_id NUMBER) IS
6290: SELECT ppsp.project_subteam_party_id, ppa.assignment_type, ppa.description, ppa.additional_information, ppa.start_date, ppa.end_date, ppa.min_resource_job_level, ppa.max_resource_job_level, ppa.resource_id
6291: FROM pa_project_assignments ppa,
6292: pa_project_subteam_parties ppsp
6293: WHERE ppa.assignment_id = l_asmt_id
6294: AND ppsp.object_type (+)= 'PA_PROJECT_ASSIGNMENTS'
6295: AND ppa.assignment_id = ppsp.object_id(+)
6296: AND ppsp.primary_subteam_flag(+) = 'Y';

Line 6575: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM

6571: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
6572: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
6573: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
6574: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
6575: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
6576: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
6577: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
6578: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
6579: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM

Line 6695: ,pa_project_subteam_parties psp

6691: BEGIN
6692: SELECT 'Y'
6693: INTO l_exists
6694: FROM pa_project_assignments asgn
6695: ,pa_project_subteam_parties psp
6696: ,pa_locations loc
6697: WHERE asgn.project_id = p_project_id
6698: AND asgn.assignment_id = p_assignment_id
6699: AND asgn.assignment_name = p_assignment_name