APPS.HR_PROCESS_PERSON_SS dependencies on HR_COMMENTS

Line 163: ,hr_comments hc

159: ,per.comment_id
160: ,hc.comment_text
161: ,pos.adjusted_svc_date
162: FROM per_all_people_f per
163: ,hr_comments hc
164: ,per_periods_of_service pos
165: WHERE per.person_id = p_person_id
166: AND p_eff_date BETWEEN per.effective_start_date and per.effective_end_date
167: AND hc.comment_id (+) = per.comment_id