APPS.MISPER_WF_SYNCH_USER_ROLE dependencies on WF_USER_ROLE_ASSIGNMENTS

Line 36: from wf_user_role_assignments

32: and trunc(p_in_effective_start_date) between effective_start_date and effective_end_date;
33:
34: Cursor C_User_Pos_Prev_rel (p_in_user_name in varchar2, p_in_effective_start_date in date) is
35: Select *
36: from wf_user_role_assignments
37: where user_name = p_in_user_name
38: and role_name like 'POS:%'
39: and start_date < (trunc(p_in_effective_start_date));
40: