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.PER_NL_DSR_ARCHIVE dependencies on PER_PEOPLE_EXTRA_INFO

Line 341: FROM per_people_extra_info

337: ,pei_information17 period_lt_3_months
338: ,pei_information18 first_call
339: ,pei_information19 exceeds_allowed_period
340: ,pei_information20 temporary_contracts
341: FROM per_people_extra_info
342: WHERE information_type = 'NL_DS_SICK_INFO'
343: AND person_id = c_person_id
344: AND c_effective_date BETWEEN fnd_date.canonical_to_date (pei_information1)
345: AND nvl (fnd_date.canonical_to_date (pei_information2),hr_general.end_of_time);

Line 1666: ,per_people_extra_info pei

1662: ,pei_information23 gender
1663: ,pei_information24 contact_ph_no
1664: ,pei_information3 l29bzw
1665: FROM per_all_assignments_f pas
1666: ,per_people_extra_info pei
1667: WHERE pas.assignment_id = p_assignment_id
1668: AND p_start_date BETWEEN pas.effective_start_date
1669: AND pas.effective_end_date
1670: AND pei.person_id = pas.person_id