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' AND wf.orig_system_id = person_id;
18:
19: CURSOR get_global_name (p_person_id per_all_people_f.person_id%TYPE)
20: IS