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.PAY_NL_NSI_PROCESS dependencies on PER_CONTACT_RELATIONSHIPS

Line 785: per_contact_relationships con

781: ee_info.Last_Name
782: ,ee_info.Previous_Last_Name
783: ,replace(replace(replace(ee_info.pre_name_adjunct,'.',''),',',''),' ','') Prefix
784: FROM per_all_people_f ee_info,
785: per_contact_relationships con
786: WHERE ee_info.person_id = con.contact_person_id
787: AND con.person_id= lp_person_id
788: AND con.contact_type='S'
789: AND lp_effective_date BETWEEN ee_info.Effective_Start_Date and ee_info.Effective_End_Date;