eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_BPL_ALERT_ADDRESS dependencies on PER_ALL_PEOPLE_F

Line 381: , per_all_people_f psn

377: SELECT psn.full_name contact_person_name
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'

Line 385: AND pho.parent_table= 'PER_ALL_PEOPLE_F'

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
387: AND con.contact_type = 'EMRG'
388: AND TRUNC(sysdate)
389: BETWEEN psn.effective_start_date