APPS.PSP_WF_EFT_PKG dependencies on PER_PEOPLE_F

Line 28: FROM per_people_f

24: -- End 8.31.99
25: CURSOR get_emp_details_csr IS
26: SELECT full_name,
27: employee_number
28: FROM per_people_f
29: WHERE person_id = L_Person_id and
30: L_end_perd between effective_start_date and effective_end_date;
31:
32: CURSOR get_period_details_csr IS

Line 40: FROM per_people_f ppf

36: WHERE template_id = l_template_id;
37:
38: CURSOR get_supervisor_csr IS
39: SELECT ppf.full_name
40: FROM per_people_f ppf
41: WHERE ppf.person_id = (select paf.supervisor_id from per_assignments_f paf
42: where paf.person_id = l_person_id
43: AND paf.assignment_type ='E' --Added for bug 2624259.
44: AND l_end_perd between paf.effective_start_date and

Line 53: per_people_f ppf,

49: --For Bug 2624263: Changed the select. Selecting name from fnd_users instead of wf_users
50: CURSOR get_user_name_csr IS
51: SELECT usr.user_name
52: FROM fnd_user usr,
53: per_people_f ppf,
54: fnd_languages fndl
55: WHERE usr.employee_id = ppf.person_id
56: AND trunc ( SYSDATE ) between ppf.effective_start_date and ppf.effective_end_date
57: AND fndl.installed_flag='B'

Line 207: FROM per_people_f

203:
204: CURSOR get_emp_details_csr IS
205: SELECT full_name,
206: employee_number
207: FROM per_people_f
208: WHERE person_id = L_Person_id and
209: L_end_perd between effective_start_date and effective_end_date;
210:
211: CURSOR get_period_details_csr IS

Line 219: FROM per_people_f ppf

215: WHERE template_id = l_template_id;
216:
217: CURSOR get_supervisor_csr IS
218: SELECT ppf.full_name, ppf.person_id
219: FROM per_people_f ppf
220: WHERE ppf.person_id = (select paf.supervisor_id from per_assignments_f paf
221: where paf.person_id = l_person_id
222: AND paf.assignment_type ='E' --Added for bug 2624259.
223: AND l_end_perd between paf.effective_start_date and

Line 232: per_people_f ppf,

228: --For Bug 2624263 : Supervisor 's login name being selected from fnd_users instead of wf_users
229: CURSOR get_supervisor_login_csr IS
230: SELECT usr.user_name
231: FROM fnd_user usr,
232: per_people_f ppf,
233: fnd_languages fndl
234: WHERE usr.employee_id = ppf.person_id
235: AND trunc ( SYSDATE ) between ppf.effective_start_date and ppf.effective_end_date
236: AND fndl.installed_flag='B'