APPS.PA_ASSIGNMENTS_PUB dependencies on PA_PROJECT_SUBTEAM_PARTIES

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

3196: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
3197: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
3198: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
3199: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
3200: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
3201: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
3202: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
3203: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
3204: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM

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

4355: ,p_resource_id IN pa_resources.resource_id%TYPE := FND_API.G_MISS_NUM
4356: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
4357: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
4358: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
4359: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
4360: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
4361: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
4362: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
4363: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

Line 7268: pa_project_subteam_parties ppsp

7264:
7265: CURSOR get_asgn_info(l_asmt_id NUMBER) IS
7266: 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
7267: FROM pa_project_assignments ppa,
7268: pa_project_subteam_parties ppsp
7269: WHERE ppa.assignment_id = l_asmt_id
7270: AND ppsp.object_type (+)= 'PA_PROJECT_ASSIGNMENTS'
7271: AND ppa.assignment_id = ppsp.object_id(+)
7272: AND ppsp.primary_subteam_flag(+) = 'Y';

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

7547: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
7548: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
7549: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
7550: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
7551: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
7552: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
7553: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
7554: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
7555: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM

Line 7671: ,pa_project_subteam_parties psp

7667: BEGIN
7668: SELECT 'Y'
7669: INTO l_exists
7670: FROM pa_project_assignments asgn
7671: ,pa_project_subteam_parties psp
7672: ,pa_locations loc
7673: WHERE asgn.project_id = p_project_id
7674: AND asgn.assignment_id = p_assignment_id
7675: AND asgn.assignment_name = p_assignment_name