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_PROCESS_PERSON_SS dependencies on HR_COMMENTS

Line 157: ,hr_comments hc

153: ,per.comment_id
154: ,hc.comment_text
155: ,pos.adjusted_svc_date
156: FROM per_all_people_f per
157: ,hr_comments hc
158: ,per_periods_of_service pos
159: WHERE per.person_id = p_person_id
160: AND p_eff_date BETWEEN per.effective_start_date and per.effective_end_date
161: AND hc.comment_id (+) = per.comment_id