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 20: ,hire_date per_periods_of_service.date_start%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
21: ,applicant_number per_all_people_f.applicant_number%type default null
22: ,date_of_birth per_all_people_f.date_of_birth%type default null
23: ,email_address per_all_people_f.email_address%type default null
24: ,employee_number per_all_people_f.employee_number%type default null

Line 202: from per_periods_of_service

198: and p_effective_date between effective_start_date and effective_end_date;
199: --
200: cursor csr_pds(p_person_id number,p_effective_date date) is
201: select date_start
202: from per_periods_of_service
203: where person_id=p_person_id
204: and p_effective_date between date_start and nvl(final_process_date,p_effective_date);
205: --
206: cursor csr_app(p_person_id number,p_effective_date date) is

Line 693: ,'per_periods_of_service pds_a ','pds_a.person_id','pds_a.date_start');

689: l_a_where_clause:=build_date_where('per.person_id',p_condition,p_value
690: ,'per_applications pap_a ','pap_a.person_id','pap_a.projected_hire_date');
691: elsif p_field_name='HIRE_DATE' then
692: l_a_where_clause:=build_date_where('per.person_id',p_condition,p_value
693: ,'per_periods_of_service pds_a ','pds_a.person_id','pds_a.date_start');
694: elsif p_field_name='ASSIGNMENT_STATUS' then
695: -- Bug 4060365 Removed the first comma placed before table s_a in the 4th parameter
696: --Modified for PMxbg
697: l_a_where_clause:=build_varchar2_where('per_asg.assignment_status_type_id'

Line 874: l_from_clause:=l_from_clause||',per_periods_of_service pds';

870: ||''',''DD/MM/YYYY'')';
871: end if;
872: --
873: if hire_date is not null then
874: l_from_clause:=l_from_clause||',per_periods_of_service pds';
875: l_where_clause:=l_where_clause||' and pds.person_id=per.person_id'
876: ||' and pds.date_start=to_date('''||to_char(hire_date,'DD/MM/YYYY')
877: ||''',''DD/MM/YYYY'')';
878: end if;

Line 2446: ,hire_date in per_periods_of_service.date_start%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
2447: ,applicant_number in per_all_people_f.applicant_number%type default null
2448: ,date_of_birth in per_all_people_f.date_of_birth%type default null
2449: ,email_address in per_all_people_f.email_address%type default null
2450: ,employee_number in per_all_people_f.employee_number%type default null