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

Line 195: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;

191: l_phn_object_version_number per_phones.object_version_number%TYPE;
192: l_phone_id per_phones.phone_id%TYPE;
193: l_phn_date_to per_phones.date_to%TYPE; --Line added for bug# 878827
194: --
195: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
196: l_pds_adjusted_svc_date per_periods_of_service.adjusted_svc_date%type;
197: l_adjusted_svc_date date;
198: l_period_of_service_id per_periods_of_service.period_of_service_id%type;
199: --

Line 196: l_pds_adjusted_svc_date per_periods_of_service.adjusted_svc_date%type;

192: l_phone_id per_phones.phone_id%TYPE;
193: l_phn_date_to per_phones.date_to%TYPE; --Line added for bug# 878827
194: --
195: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
196: l_pds_adjusted_svc_date per_periods_of_service.adjusted_svc_date%type;
197: l_adjusted_svc_date date;
198: l_period_of_service_id per_periods_of_service.period_of_service_id%type;
199: --
200: cursor csr_bg is

Line 198: l_period_of_service_id per_periods_of_service.period_of_service_id%type;

194: --
195: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
196: l_pds_adjusted_svc_date per_periods_of_service.adjusted_svc_date%type;
197: l_adjusted_svc_date date;
198: l_period_of_service_id per_periods_of_service.period_of_service_id%type;
199: --
200: cursor csr_bg is
201: select per.business_group_id
202: from per_people_f per

Line 214: from per_periods_of_service pds

210: where pet.person_type_id=p_person_type_id1;
211: --
212: cursor csr_period_of_service is
213: select pds.period_of_service_id, pds.object_version_number, pds.adjusted_svc_date
214: from per_periods_of_service pds
215: where pds.person_id = p_person_id
216: and l_effective_date between
217: nvl(pds.date_start, hr_general.start_of_time)
218: and nvl(pds.actual_termination_date,hr_general.end_of_time);

Line 689: -- Update per_periods_of_service

685: end if;
686: end if;
687: -- PTU : End of changes
688: --
689: -- Update per_periods_of_service
690: --
691: open csr_period_of_service;
692: fetch csr_period_of_service
693: into l_period_of_service_id, l_pds_object_version_number,l_pds_adjusted_svc_date;