APPS.BEN_FYI_NTFN_SS dependencies on PQH_ROLES

Line 20: from pqh_roles pqr

16: ,result out nocopy varchar2
17: ) is
18:
19: cursor c1 is select pqr.role_id,pqr.role_name
20: from pqh_roles pqr
21: where pqr.role_type_cd ='SSBNFT' ;
22:
23: cursor c2(l_role_id number) is
24: select pei.person_id,

Line 31: pqh_roles rls

27: usr.user_id user_id
28: from per_people_extra_info pei,
29: per_all_people_f ppf,
30: fnd_user usr,
31: pqh_roles rls
32: where pei.information_type = 'PQH_ROLE_USERS'
33: and pei.person_id = ppf.person_id
34: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
35: and usr.employee_id = ppf.person_id