2408: papf.business_group_id, pc.assignment_id, pc.person_id,
2409: pc.status_code, papf.full_name
2410: FROM per_personal_scorecards pc,
2411: per_people_f papf,
2412: per_assignments_f paaf
2413: WHERE pc.plan_id = p_plan_id
2414: AND pc.assignment_id = paaf.assignment_id
2415: AND pc.person_id = papf.person_id
2416: AND p_effective_date BETWEEN paaf.effective_start_date