APPS.PA_COMPETENCE_PVT dependencies on PA_PROJECT_ASSIGNMENTS

Line 16: p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM,

12: --
13: PROCEDURE Add_competence_element
14: ( p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
15: p_object_id IN PA_ASSIGNMENTS_PUB.assignment_id_tbl_type,
16: p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM,
17: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
18: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
19: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
20: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 89: FROM pa_project_assignments

85: --dbms_output.put_line('p_project_id = NULL in PUB, l_first_assignment_id: '|| l_first_assignment_id);
86: BEGIN
87: SELECT project_id
88: INTO l_project_id
89: FROM pa_project_assignments
90: WHERE assignment_id = l_first_assignment_id;
91: EXCEPTION
92: WHEN NO_DATA_FOUND THEN
93: Check_Error (p_return_status => FND_API.G_RET_STS_ERROR