APPS.HR_WPM_NTF_UTIL dependencies on PER_ALL_ASSIGNMENTS_F

Line 35: FROM per_all_assignments_f paf, per_personal_scorecards sc

31:
32: CURSOR get_sc_manager_person_id (p_sc_id NUMBER)
33: IS
34: SELECT paf.supervisor_id
35: FROM per_all_assignments_f paf, per_personal_scorecards sc
36: WHERE sc.scorecard_id = p_sc_id
37: AND sc.assignment_id = paf.assignment_id
38: AND TRUNC (SYSDATE) BETWEEN paf.effective_start_date AND paf.effective_end_date
39: AND paf.assignment_type IN ('E', 'C');

Line 57: per_all_assignments_f wrk,

53: CURSOR get_pos_manager_id (p_sc_id per_personal_scorecards.scorecard_id%TYPE)
54: IS
55: SELECT sup.person_id
56: FROM per_personal_scorecards sc,
57: per_all_assignments_f wrk,
58: per_pos_structure_elements ppse,
59: per_all_assignments_f sup,
60: per_perf_mgmt_plans plans
61: WHERE sc.scorecard_id = p_sc_id

Line 59: per_all_assignments_f sup,

55: SELECT sup.person_id
56: FROM per_personal_scorecards sc,
57: per_all_assignments_f wrk,
58: per_pos_structure_elements ppse,
59: per_all_assignments_f sup,
60: per_perf_mgmt_plans plans
61: WHERE sc.scorecard_id = p_sc_id
62: AND plans.plan_id = sc.plan_id
63: AND sc.assignment_id = wrk.assignment_id