APPS.PER_PMP_MASS_NOTIFICATION dependencies on PER_PEOPLE_F

Line 28: FROM per_people_f ppf

24: p_effective_date DATE) IS
25: SELECT ppf.person_id,
26: usr.name user_name,
27: ppf.full_name
28: FROM per_people_f ppf
29: ,wf_roles usr
30: WHERE ppf.person_id = p_person_id
31: AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
32: AND ppf.person_id = usr.orig_system_id(+)

Line 44: ,per_people_f ppf

40: usr.name user_name,
41: ppf.full_name
42: FROM per_personal_scorecards sc
43: ,per_assignments_f paf
44: ,per_people_f ppf
45: ,wf_roles usr
46: WHERE sc.plan_id = p_plan_id
47: AND p_effective_date BETWEEN sc.start_date AND sc.end_date
48: AND sc.assignment_id = paf.assignment_id

Line 63: ,per_people_f ppf

59: usr.name user_name,
60: ppf.full_name
61: FROM per_personal_scorecards sc
62: ,per_assignments_f paf
63: ,per_people_f ppf
64: ,wf_roles usr
65: WHERE sc.plan_id = p_plan_id
66: AND p_effective_date BETWEEN sc.start_date AND sc.end_date
67: AND sc.assignment_id = paf.assignment_id

Line 84: ,per_people_f ppf

80: ,usr.name user_name
81: ,ppf.full_name
82: FROM per_personal_scorecards sc
83: ,per_assignments_f paf
84: ,per_people_f ppf
85: ,wf_roles usr
86: WHERE sc.plan_id = p_plan_id
87: AND p_effective_date BETWEEN sc.start_date AND sc.end_date
88: AND sc.status_code = p_status

Line 106: ,per_people_f ppf

102: ,usr.name user_name
103: ,ppf.full_name
104: FROM per_personal_scorecards sc
105: ,per_assignments_f paf
106: ,per_people_f ppf
107: ,wf_roles usr
108: WHERE sc.plan_id = p_plan_id
109: AND p_effective_date BETWEEN sc.start_date AND sc.end_date
110: AND sc.status_code = p_status

Line 126: ,per_people_f ppf

122: ,usr.name user_name
123: ,ppf.full_name
124: FROM per_assignments_f paf
125: ,per_personal_scorecards sc
126: ,per_people_f ppf
127: ,wf_roles usr
128: WHERE sc.plan_id = p_plan_id
129: AND p_effective_date BETWEEN sc.start_date AND sc.end_date
130: AND sc.status_code <> 'PUBLISHED'

Line 146: ,per_people_f ppf

142: ,usr.name user_name
143: ,ppf.full_name
144: FROM per_assignments_f paf
145: ,per_personal_scorecards sc
146: ,per_people_f ppf
147: ,wf_roles usr
148: WHERE sc.plan_id = p_plan_id
149: AND p_effective_date BETWEEN sc.start_date AND sc.end_date
150: AND sc.status_code <> 'PUBLISHED'

Line 166: ,per_people_f ppf

162: ,usr.name user_name
163: ,ppf.full_name
164: FROM per_assignments_f paf
165: ,per_appraisals apr
166: ,per_people_f ppf
167: ,wf_roles usr
168: WHERE apr.plan_id = p_plan_id
169: AND apr.appraisal_system_status = p_status_code
170: AND apr.appraisee_person_id = paf.person_id

Line 185: ,per_people_f ppf

181: ,usr.name user_name
182: ,ppf.full_name
183: FROM per_assignments_f paf
184: ,per_appraisals apr
185: ,per_people_f ppf
186: ,wf_roles usr
187: WHERE apr.plan_id = p_plan_id
188: AND apr.appraisal_system_status = p_status_code
189: AND apr.main_appraiser_id = paf.person_id