APPS.IEM_EMAIL_PROC_PVT dependencies on PER_WORKFORCE_CURRENT_X

Line 531: from per_workforce_current_x

527: --if this fails it will go to exception block anyways
528: -- no need to validation here.
529:
530: Select person_id into l_contact_id
531: from per_workforce_current_x
532: Where upper(email_address)=upper(l_sender);
533: --end of fix siahmed for bug 13702109
534:
535: IEM_GETCUST_PVT.GETCUSTOMERID

Line 1722: from per_workforce_current_x

1718: if l_acct_type='I' then -- select the party id from profile
1719: l_emp_flag:='Y';
1720: BEGIN
1721: Select person_id into l_contact_id
1722: from per_workforce_current_x
1723: Where upper(email_address)=upper(l_sender);
1724: exception when others then
1725: l_contact_id:=null;
1726: END;

Line 6187: from per_workforce_current_x a

6183: BEGIN
6184: l_contact_email:= get_tag_data(contact_rec.start_tag, contact_rec.end_tag, p_message_id);
6185: Select a.person_id, 'EMAIL','EMPLOYEE'
6186: into g_contact_party_id, g_contact_point_type , g_contact_party_type
6187: from per_workforce_current_x a
6188: where UPPER(a.email_Address) = upper(l_contact_email);
6189: EXCEPTION
6190: when TOO_MANY_ROWS then
6191: l_logmessage:='internal contact email:'||l_contact_email||' fetch returned too many rows'|| SQL%ROWCOUNT;