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.

[Home] [Help]

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 853: || ' ,per_person_types ppt'

849: l_where_clause:=l_where_clause
850: ||' AND per.person_id IN'
851: || ' (SELECT ptu.person_id'
852: || ' FROM per_person_type_usages_f ptu'
853: || ' ,per_person_types ppt'
854: || ' WHERE ptu.person_type_id = ppt.person_type_id'
855: || ' AND ppt.system_person_type ='''||system_person_type||''''
856: || ' AND '||l_effective_date_clause
857: || ' BETWEEN ptu.effective_start_date'

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

2437: query_id in number
2438: ,business_group_id in per_all_people_f.business_group_id%type
2439: ,business_group_name in per_business_groups.name%type
2440: ,person_id in per_all_people_f.person_id%type default null
2441: ,person_type in per_person_types.user_person_type%type default null
2442: ,system_person_type in per_person_types.system_person_type%type default null
2443: ,person_type_id in per_all_people_f.person_type_id%type default null
2444: ,last_name in per_all_people_f.last_name%type default null
2445: ,start_date in per_all_people_f.start_date%type default null

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

2438: ,business_group_id in per_all_people_f.business_group_id%type
2439: ,business_group_name in per_business_groups.name%type
2440: ,person_id in per_all_people_f.person_id%type default null
2441: ,person_type in per_person_types.user_person_type%type default null
2442: ,system_person_type in per_person_types.system_person_type%type default null
2443: ,person_type_id in per_all_people_f.person_type_id%type default null
2444: ,last_name in per_all_people_f.last_name%type default null
2445: ,start_date in per_all_people_f.start_date%type default null
2446: ,hire_date in per_periods_of_service.date_start%type default null