APPS.HR_BPL_ALERT_ADDRESS dependencies on PER_PHONES

Line 382: , per_phones pho

378: , pho.phone_number contact_phone_number
379: , pho.phone_type phone_type
380: FROM per_contact_relationships con
381: , per_all_people_f psn
382: , per_phones pho
383: WHERE psn.person_id = con.contact_person_id
384: AND psn.person_id = pho.parent_id (+)
385: AND pho.parent_table= 'PER_ALL_PEOPLE_F'
386: AND con.person_id = cp_person_id