APPS.PSP_WF_EFT_PKG dependencies on FND_USER

Line 49: --For Bug 2624263: Changed the select. Selecting name from fnd_users instead of wf_users

45: paf.effective_end_date and
46: paf.primary_flag = 'Y' ) and
47: l_end_perd between ppf.effective_start_date and ppf.effective_end_date;
48:
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,

Line 52: FROM fnd_user usr,

48:
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

Line 228: --For Bug 2624263 : Supervisor 's login name being selected from fnd_users instead of wf_users

224: paf.effective_end_date and
225: primary_flag = 'Y') and
226: l_end_perd between ppf.effective_start_date and ppf.effective_end_date;
227:
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,

Line 231: FROM fnd_user usr,

227:
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