DBA Data[Home] [Help]

APPS.HR_PERSON_ATT dependencies on PER_ALL_PEOPLE_F

Line 311: ,per_all_people_f per

307: ,per.effective_start_date
308: ,per.effective_end_date
309: ,hc.comment_text
310: from hr_comments hc
311: ,per_all_people_f per
312: where per.person_id = p_person_id
313: and per.effective_end_date >= l_constant_effective_date
314: and hc.comment_id (+) = per.comment_id
315: order by per.effective_end_date asc;

Line 443: ,per_all_people_f per

439: ,per.effective_start_date
440: ,per.effective_end_date
441: ,hc.comment_text
442: from hr_comments hc
443: ,per_all_people_f per
444: where per.person_id = p_person_id
445: and per.effective_end_date < l_constant_effective_date
446: and hc.comment_id (+) = per.comment_id
447: order by per.effective_end_date desc;