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_PERSON_TYPES

Line 10: ,system_person_type per_person_types.system_person_type%type

6: ,business_group_name per_business_groups.name%type
7: ,per_effective_start_date per_all_people_f.effective_start_date%type
8: ,per_effective_end_date per_all_people_f.effective_end_date%type
9: ,person_type varchar2(240)
10: ,system_person_type per_person_types.system_person_type%type
11: ,last_name per_all_people_f.last_name%type
12: ,start_date per_all_people_f.start_date%type
13: ,applicant_number per_all_people_f.applicant_number%type
14: ,background_chk_stat_meaning hr_lookups.meaning%type

Line 597: ,person_type per_person_types.user_person_type%type default null

593: ,p_effective_date date
594: ,business_group_id per_all_people_f.business_group_id%type
595: ,business_group_name per_business_groups.name%type default null
596: ,person_id per_all_people_f.person_id%type default null
597: ,person_type per_person_types.user_person_type%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

Line 598: ,system_person_type per_person_types.system_person_type%type default null

594: ,business_group_id per_all_people_f.business_group_id%type
595: ,business_group_name per_business_groups.name%type default null
596: ,person_id per_all_people_f.person_id%type default null
597: ,person_type per_person_types.user_person_type%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

Line 701: ,person_type in per_person_types.user_person_type%type default null

697: query_id in number
698: ,business_group_id in per_all_people_f.business_group_id%type
699: ,business_group_name in per_business_groups.name%type
700: ,person_id in per_all_people_f.person_id%type default null
701: ,person_type in per_person_types.user_person_type%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

Line 702: ,system_person_type in per_person_types.system_person_type%type default null

698: ,business_group_id in per_all_people_f.business_group_id%type
699: ,business_group_name in per_business_groups.name%type
700: ,person_id in per_all_people_f.person_id%type default null
701: ,person_type in per_person_types.user_person_type%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