DBA Data[Home] [Help]

APPS.PER_PMP_MASS_NOTIFICATION dependencies on PER_APPRAISALS

Line 165: ,per_appraisals apr

161: SELECT DISTINCT paf.person_id
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

Line 184: ,per_appraisals apr

180: SELECT DISTINCT ppf.person_id
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