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.PER_QH_FIND_QUERY dependencies on PER_PERIODS_OF_SERVICE

Line 256: ,hire_date per_periods_of_service.date_start%type

252: ,per_information30 per_all_people_f.attribute30%type
253: ,per_information30_v varchar2(150)
254: ,per_information30_m varchar2(150)
255: ,date_of_death per_all_people_f.date_of_death%type
256: ,hire_date per_periods_of_service.date_start%type
257: ,projected_hire_date per_applications.projected_hire_date%type
258: ,assignment_id per_all_assignments_f.assignment_id%type
259: ,asg_effective_start_date per_all_assignments_f.effective_start_date%type
260: ,asg_effective_end_date per_all_assignments_f.effective_end_date%type

Line 602: ,hire_date per_periods_of_service.date_start%type default null

598: ,system_person_type per_person_types.system_person_type%type default null
599: ,person_type_id per_all_people_f.person_type_id%type default null
600: ,last_name per_all_people_f.last_name%type default null
601: ,start_date per_all_people_f.start_date%type default null
602: ,hire_date per_periods_of_service.date_start%type default null
603: ,applicant_number per_all_people_f.applicant_number%type default null
604: ,date_of_birth per_all_people_f.date_of_birth%type default null
605: ,email_address per_all_people_f.email_address%type default null
606: ,employee_number per_all_people_f.employee_number%type default null

Line 706: ,hire_date in per_periods_of_service.date_start%type default null

702: ,system_person_type in per_person_types.system_person_type%type default null
703: ,person_type_id in per_all_people_f.person_type_id%type default null
704: ,last_name in per_all_people_f.last_name%type default null
705: ,start_date in per_all_people_f.start_date%type default null
706: ,hire_date in per_periods_of_service.date_start%type default null
707: ,applicant_number in per_all_people_f.applicant_number%type default null
708: ,date_of_birth in per_all_people_f.date_of_birth%type default null
709: ,email_address in per_all_people_f.email_address%type default null
710: ,employee_number in per_all_people_f.employee_number%type default null