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.

[Home] [Help]

APPS.HR_APPLICANT_DATAUPD dependencies on HR_GENERAL

Line 103: AND paf.effective_end_date <> hr_general.end_of_time

99: FROM per_all_assignments_f paf
100: WHERE paf.application_id = p_application_id
101: AND paf.assignment_type = 'A'
102: AND paf.effective_end_date > p_termination_date
103: AND paf.effective_end_date <> hr_general.end_of_time
104: AND paf.effective_start_date =
105: (select max(effective_start_date) -- do not consider DT updates
106: from per_all_assignments_f paf2
107: where paf2.assignment_id = paf.assignment_id