APPS.HR_WPM_NTF_UTIL dependencies on PER_ALL_ASSIGNMENTS_F

Line 32: FROM per_all_assignments_f paf

28: select * from per_personal_scorecards where scorecard_id = p_scorecard_id;
29:
30: CURSOR get_sc_manager_person_id(p_sc_id NUMBER) IS
31: SELECT paf.supervisor_id
32: FROM per_all_assignments_f paf
33: ,per_personal_scorecards sc
34: WHERE sc.scorecard_id = p_sc_id
35: AND sc.assignment_id = paf.assignment_id
36: AND trunc(sysdate) between paf.effective_start_date and paf.effective_end_date