APPS.PQH_WORKFLOW dependencies on PER_ALL_PEOPLE_F

Line 146: from per_people_extra_info pei , per_all_people_f ppf, fnd_user usr

142: p_session_date in date) return number is
143: l_role_id number;
144: cursor c_get_user_role (p_user_id number) is
145: select decode(information_type, 'PQH_ROLE_USERS', to_number(pei.pei_information3), 0) role_id
146: from per_people_extra_info pei , per_all_people_f ppf, fnd_user usr
147: WHERE information_type = 'PQH_ROLE_USERS' and pei.person_id = ppf.person_id
148: and p_session_date between ppf.effective_start_date and ppf.effective_end_date
149: and usr.employee_id = ppf.person_id
150: and nvl(pei.pei_information5,'Y')='Y'

Line 383: from per_people_extra_info pei , per_all_people_f ppf, fnd_user usr

379: cursor c1 is select role_name from pqh_roles
380: where role_id = p_role_id
381: and nvl(enable_flag,'X') = 'Y';
382: cursor c3 is select 'X'
383: from per_people_extra_info pei , per_all_people_f ppf, fnd_user usr
384: WHERE information_type = 'PQH_ROLE_USERS' and pei.person_id = ppf.person_id
385: and p_session_date between ppf.effective_start_date and ppf.effective_end_date
386: and usr.employee_id = ppf.person_id
387: and decode(information_type, 'PQH_ROLE_USERS', to_number(pei.pei_information3), 0)= p_role_id

Line 436: from per_people_extra_info pei , per_all_people_f ppf, fnd_user usr

432: where rht.forwarded_to_member_id = rlm.routing_list_member_id
433: and rht.routing_history_id = p_routing_history_id;
434: cursor c_role_users(p_user_id number, p_role_id number) is
435: select 'X'
436: from per_people_extra_info pei , per_all_people_f ppf, fnd_user usr
437: WHERE information_type = 'PQH_ROLE_USERS' and pei.person_id = ppf.person_id
438: and sysdate between ppf.effective_start_date and ppf.effective_end_date
439: and usr.employee_id = ppf.person_id
440: and decode(information_type, 'PQH_ROLE_USERS', to_number(pei.pei_information3), 0)= p_role_id

Line 497: from per_people_extra_info pei , per_all_people_f ppf

493: and sysdate between effective_start_date and effective_end_date;
494:
495: cursor c_person_role(p_person_id number) is
496: select decode(information_type, 'PQH_ROLE_USERS', to_number(pei.pei_information3), 0) role_id
497: from per_people_extra_info pei , per_all_people_f ppf
498: WHERE information_type = 'PQH_ROLE_USERS' and pei.person_id = ppf.person_id
499: and sysdate between ppf.effective_start_date and ppf.effective_end_date
500: and ppf.person_id = p_person_id
501: and nvl(pei.pei_information5,'Y')='Y'