APPS.IEM_EMAIL_PROC_PVT dependencies on PER_WORKFORCE_X

Line 6160: from per_workforce_x a,per_phones b

6156: l_contact_phone:= get_tag_data(contact_rec.start_tag, contact_rec.end_tag, p_message_id);
6157: l_contact_phone:= REGEXP_REPLACE(l_contact_phone,'([[:punct:]|[:space:]]*)');
6158: Select a.person_id, b.phone_id, 'PHONE','EMPLOYEE'
6159: into g_contact_party_id,g_contact_point_id, g_contact_point_type, g_contact_party_type
6160: from per_workforce_x a,per_phones b
6161: where a.person_id = b.parent_id
6162: and REGEXP_REPLACE(b.phone_number,'([[:punct:]|[:space:]]*)') = l_contact_phone;
6163: EXCEPTION
6164: when TOO_MANY_ROWS then