DBA Data[Home] [Help]

APPS.HR_WPM_NTF_UTIL dependencies on WF_ROLES

Line 16: from wf_roles wf

12: -- to be clarified for orig_system
13: cursor get_role(person_id per_all_people_f.person_id%TYPE)
14: is
15: select wf.name role_name
16: from wf_roles wf
17: where wf.orig_system = 'PER'
18: and wf.orig_system_id = person_id;
19:
20: cursor get_global_name(p_person_id per_all_people_f.person_id%TYPE)