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.HR_PERSON_ATT dependencies on HR_COMMENTS

Line 310: from hr_comments hc

306: ,per.global_person_id
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

Line 442: from hr_comments hc

438: ,per.global_person_id
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

Line 464: l_comments hr_comments.comment_text%type;

460: l_work_telephone per_people_f.work_telephone%type;
461: l_suffix per_people_f.suffix%type;
462: l_person_type_id per_people_f.person_type_id%type;
463: l_applicant_number per_people_f.applicant_number%type;
464: l_comments hr_comments.comment_text%type;
465: l_date_employee_data_verified per_people_f.date_employee_data_verified%type;
466: l_expense_check_send_to_addres per_people_f.expense_check_send_to_address%type;
467: l_national_identifier per_people_f.national_identifier%type;
468: l_registered_disabled_flag per_people_f.registered_disabled_flag%type;