eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PMP_MASS_NOTIFICATION dependencies on PER_PEOPLE_F

Line 37: FROM per_people_f ppf, wf_roles usr

33: IS
34: SELECT ppf.person_id,
35: usr.NAME user_name,
36: ppf.full_name
37: FROM per_people_f ppf, wf_roles usr
38: WHERE ppf.person_id = p_person_id
39: AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
40: AND ppf.person_id = usr.orig_system_id(+)
41: AND usr.orig_system(+) = 'PER';

Line 52: per_people_f ppf,

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
56: AND sc.assignment_id = paf.assignment_id

Line 73: per_people_f ppf,

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
77: AND sc.assignment_id = paf.assignment_id

Line 97: per_people_f ppf,

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
101: AND sc.status_code = p_status

Line 119: per_people_f ppf,

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
123: AND sc.status_code = p_status

Line 140: per_people_f ppf,

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
143: AND p_effective_date BETWEEN sc.start_date AND sc.end_date
144: AND sc.status_code <> 'PUBLISHED'

Line 162: per_people_f ppf,

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
165: AND p_effective_date BETWEEN sc.start_date AND sc.end_date
166: AND sc.status_code <> 'PUBLISHED'

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