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_ALL_PEOPLE_F

Line 768: FROM per_all_people_f ee_info

764: ,ee_info.Marital_Status
765: ,ee_info.Date_Of_Birth
766: ,ee_info.Employee_Number
767: ,paa.Assignment_Number
768: FROM per_all_people_f ee_info
769: ,per_all_assignments_f paa
770: WHERE ee_info.person_id = lp_person_id
771: AND ee_info.person_id = paa.person_id
772: AND paa.assignment_id = lp_assignment_id

Line 784: FROM per_all_people_f ee_info,

780: SELECT
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'

Line 1880: ,per_all_people_f pap

1876: ,scl_flx.SEGMENT3 Employment_SubType
1877: ,scl_flx.SEGMENT6 Work_Pattern
1878: FROM
1879: per_all_assignments_f paa
1880: ,per_all_people_f pap
1881: ,hr_soft_coding_keyflex scl_flx
1882: WHERE paa.business_group_id = lp_business_group_id
1883: and paa.person_id
1884: BETWEEN lp_start_person_id AND lp_end_person_id