APPS.MISPER_WF_SYNCH_USER_ROLE dependencies on PER_ALL_PEOPLE_F

Line 30: from per_all_people_f

26: p_event in out NOCOPY WF_EVENT_T) return varchar2 is
27:
28: Cursor C_User_Person (p_in_party_id in number, p_in_effective_start_date in date) is
29: Select distinct person_id,business_group_id,effective_start_date,effective_end_date
30: from per_all_people_f
31: where party_id = p_in_party_id
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