APPS.PER_PMP_MASS_NOTIFICATION dependencies on PER_ASSIGNMENTS_F

Line 51: per_assignments_f paf,

47: SELECT DISTINCT ppf.person_id,
48: usr.NAME user_name,
49: ppf.full_name
50: FROM per_personal_scorecards sc,
51: per_assignments_f paf,
52: per_people_f ppf,
53: wf_roles usr
54: WHERE sc.plan_id = p_plan_id
55: AND p_effective_date BETWEEN sc.start_date AND sc.end_date

Line 72: per_assignments_f paf,

68: SELECT DISTINCT ppf.person_id,
69: usr.NAME user_name,
70: ppf.full_name
71: FROM per_personal_scorecards sc,
72: per_assignments_f paf,
73: per_people_f ppf,
74: wf_roles usr
75: WHERE sc.plan_id = p_plan_id
76: AND p_effective_date BETWEEN sc.start_date AND sc.end_date

Line 96: per_assignments_f paf,

92: SELECT DISTINCT ppf.person_id,
93: usr.NAME user_name,
94: ppf.full_name
95: FROM per_personal_scorecards sc,
96: per_assignments_f paf,
97: per_people_f ppf,
98: wf_roles usr
99: WHERE sc.plan_id = p_plan_id
100: AND p_effective_date BETWEEN sc.start_date AND sc.end_date

Line 118: per_assignments_f paf,

114: SELECT DISTINCT ppf.person_id,
115: usr.NAME user_name,
116: ppf.full_name
117: FROM per_personal_scorecards sc,
118: per_assignments_f paf,
119: per_people_f ppf,
120: wf_roles usr
121: WHERE sc.plan_id = p_plan_id
122: AND p_effective_date BETWEEN sc.start_date AND sc.end_date

Line 138: FROM per_assignments_f paf,

134: IS
135: SELECT DISTINCT ppf.person_id,
136: usr.NAME user_name,
137: ppf.full_name
138: FROM per_assignments_f paf,
139: per_personal_scorecards sc,
140: per_people_f ppf,
141: wf_roles usr
142: WHERE sc.plan_id = p_plan_id

Line 160: FROM per_assignments_f paf,

156: IS
157: SELECT DISTINCT ppf.person_id,
158: usr.NAME user_name,
159: ppf.full_name
160: FROM per_assignments_f paf,
161: per_personal_scorecards sc,
162: per_people_f ppf,
163: wf_roles usr
164: WHERE sc.plan_id = p_plan_id

Line 182: FROM per_assignments_f paf, per_appraisals apr, per_people_f ppf, wf_roles usr

178: IS
179: SELECT DISTINCT paf.person_id,
180: usr.NAME user_name,
181: ppf.full_name
182: FROM per_assignments_f paf, per_appraisals apr, per_people_f ppf, wf_roles usr
183: WHERE apr.plan_id = p_plan_id
184: AND apr.appraisal_system_status = p_status_code
185: AND apr.appraisee_person_id = paf.person_id
186: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 199: FROM per_assignments_f paf, per_appraisals apr, per_people_f ppf, wf_roles usr

195: IS
196: SELECT DISTINCT ppf.person_id,
197: usr.NAME user_name,
198: ppf.full_name
199: FROM per_assignments_f paf, per_appraisals apr, per_people_f ppf, wf_roles usr
200: WHERE apr.plan_id = p_plan_id
201: AND apr.appraisal_system_status = p_status_code
202: AND apr.main_appraiser_id = paf.person_id
203: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date