DBA Data[Home] [Help]

APPS.GMS_CLIENT_EXTN_BUDGET_WF dependencies on PER_PEOPLE_F

Line 251: FROM fnd_user f, per_people_f p /*Bug 5122724 */

247: --
248: CURSOR l_starter_full_name_csr(p_starter_user_id NUMBER )
249: IS
250: SELECT p.first_name||' '||p.last_name
251: FROM fnd_user f, per_people_f p /*Bug 5122724 */
252: where p.effective_start_date = (select
253: min(pp.effective_start_date) from per_all_people_f pp where pp.person_id =
254: p.person_id and pp.effective_end_date >=trunc(sysdate)) and
255: ((p.employee_number is not null) or (p.npw_number is not null))

Line 989: FROM fnd_user f, per_people_f p

985: --
986: CURSOR l_starter_full_name_csr(p_starter_user_id NUMBER )
987: IS
988: SELECT p.first_name||' '||p.last_name /* Bug 5122724 */
989: FROM fnd_user f, per_people_f p
990: where p.effective_start_date = (select
991: min(pp.effective_start_date) from per_all_people_f pp where pp.person_id =
992: p.person_id and pp.effective_end_date >=trunc(sysdate)) and
993: ((p.employee_number is not null) or (p.npw_number is not null))