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_ASSIGNMENTS_F

Line 43: ,per_assignments_f paf

39: SELECT distinct ppf.person_id,
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

Line 62: ,per_assignments_f paf

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

Line 83: ,per_assignments_f paf

79: SELECT distinct ppf.person_id
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

Line 105: ,per_assignments_f paf

101: SELECT distinct ppf.person_id
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

Line 124: FROM per_assignments_f paf

120: ,p_effective_date IN DATE) IS
121: SELECT DISTINCT ppf.person_id
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

Line 144: FROM per_assignments_f paf

140: ,p_effective_date IN DATE) IS
141: SELECT DISTINCT ppf.person_id
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

Line 164: FROM per_assignments_f paf

160: ,p_status_code IN VARCHAR2) IS
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

Line 183: FROM per_assignments_f paf

179: ,p_status_code IN VARCHAR2) IS
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