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 15: ,person_type per_person_types.user_person_type%type default null

11: ,p_effective_date date
12: ,business_group_id per_all_people_f.business_group_id%type
13: ,business_group_name per_business_groups.name%type default null
14: ,person_id per_all_people_f.person_id%type default null
15: ,person_type per_person_types.user_person_type%type default null
16: ,system_person_type per_person_types.system_person_type%type default null
17: ,person_type_id per_all_people_f.person_type_id%type default null
18: ,last_name per_all_people_f.last_name%type default null
19: ,start_date per_all_people_f.start_date%type default null

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

12: ,business_group_id per_all_people_f.business_group_id%type
13: ,business_group_name per_business_groups.name%type default null
14: ,person_id per_all_people_f.person_id%type default null
15: ,person_type per_person_types.user_person_type%type default null
16: ,system_person_type per_person_types.system_person_type%type default null
17: ,person_type_id per_all_people_f.person_type_id%type default null
18: ,last_name per_all_people_f.last_name%type default null
19: ,start_date per_all_people_f.start_date%type default null
20: ,hire_date per_periods_of_service.date_start%type default null

Line 613: ,'per_person_type_usages_f ptua, per_person_types_tl ppttla'

609: l_a_where_clause:=build_varchar2_where
610: ('per.person_id'
611: ,p_condition
612: ,p_value
613: ,'per_person_type_usages_f ptua, per_person_types_tl ppttla'
614: ,'ptua.person_id'
615: ,'ppttla.user_person_type'
616: ,' AND ptua.person_type_id = ppttla.person_type_id'
617: ||' AND ppttla.language=userenv(''LANG'')'

Line 839: || ' ,per_person_types_tl ppttl'

835: /* l_where_clause:=l_where_clause
836: ||' AND per.person_id IN'
837: || ' (SELECT ptu.person_id'
838: || ' FROM per_person_type_usages_f ptu'
839: || ' ,per_person_types_tl ppttl'
840: || ' WHERE ptu.person_type_id = ppttl.person_type_id'
841: || ' AND UPPER(ppttl.user_person_type)'
842: || ' LIKE '''||upper(replace(person_type,g_quote,g_quote||g_quote))||''''
843: || ' AND ppttl.language = userenv(''LANG'')'

Line 852: || ' ,per_person_types_tl ppttl'

848: l_where_clause:=l_where_clause
849: ||' AND EXISTS'
850: || ' (SELECT /*+ push_subq no_unnest */ 1'
851: || ' FROM per_person_type_usages_f ptu'
852: || ' ,per_person_types_tl ppttl'
853: || ' WHERE ptu.person_type_id = ppttl.person_type_id'
854: || ' AND ptu.person_id=per.person_id'
855: || ' AND UPPER(ppttl.user_person_type)'
856: || ' LIKE '''||upper(replace(person_type,g_quote,g_quote||g_quote))||''''

Line 869: || ' ,per_person_types ppt'

865: l_where_clause:=l_where_clause
866: ||' AND per.person_id IN'
867: || ' (SELECT ptu.person_id'
868: || ' FROM per_person_type_usages_f ptu'
869: || ' ,per_person_types ppt'
870: || ' WHERE ptu.person_type_id = ppt.person_type_id'
871: || ' AND ppt.system_person_type ='''||system_person_type||''''
872: || ' AND '||l_effective_date_clause
873: || ' BETWEEN ptu.effective_start_date'

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

2453: query_id in number
2454: ,business_group_id in per_all_people_f.business_group_id%type
2455: ,business_group_name in per_business_groups.name%type
2456: ,person_id in per_all_people_f.person_id%type default null
2457: ,person_type in per_person_types.user_person_type%type default null
2458: ,system_person_type in per_person_types.system_person_type%type default null
2459: ,person_type_id in per_all_people_f.person_type_id%type default null
2460: ,last_name in per_all_people_f.last_name%type default null
2461: ,start_date in per_all_people_f.start_date%type default null

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

2454: ,business_group_id in per_all_people_f.business_group_id%type
2455: ,business_group_name in per_business_groups.name%type
2456: ,person_id in per_all_people_f.person_id%type default null
2457: ,person_type in per_person_types.user_person_type%type default null
2458: ,system_person_type in per_person_types.system_person_type%type default null
2459: ,person_type_id in per_all_people_f.person_type_id%type default null
2460: ,last_name in per_all_people_f.last_name%type default null
2461: ,start_date in per_all_people_f.start_date%type default null
2462: ,hire_date in per_periods_of_service.date_start%type default null