DBA Data[Home] [Help]

APPS.PA_UTILS4 dependencies on PA_PROJECT_ASSIGNMENTS

Line 241: ,pa_project_assignments ppasgn

237: decode(ppasgn.work_type_id,NULL,pp.work_type_id,ppasgn.work_type_id)
238: ,t.work_type_id)
239: ) work_type_id
240: FROM pa_projects_all pp
241: ,pa_project_assignments ppasgn
242: ,pa_tasks t
243: WHERE pp.project_id = p_project_id
244: AND t.task_id = p_task_id
245: AND t.project_id = pp.project_id

Line 419: FROM pa_project_assignments

415: Else
416:
417: SELECT assignment_name
418: INTO l_assignment_name
419: FROM pa_project_assignments
420: WHERE assignment_id = p_assignment_id;
421:
422: End If;
423: pa_utils4.G_AssignNameRecTab(l_assignmentId).assignment_name := l_assignment_name;