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_PHONES

Line 190: l_old_work_telephone per_phones.phone_number%TYPE;

186: l_name_combination_warning boolean;
187: l_assign_payroll_warning boolean;
188: l_orig_hire_warning boolean;
189: --
190: l_old_work_telephone per_phones.phone_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: --

Line 191: l_phn_object_version_number per_phones.object_version_number%TYPE;

187: l_assign_payroll_warning boolean;
188: l_orig_hire_warning boolean;
189: --
190: l_old_work_telephone per_phones.phone_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;

Line 192: l_phone_id per_phones.phone_id%TYPE;

188: l_orig_hire_warning boolean;
189: --
190: l_old_work_telephone per_phones.phone_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;

Line 193: l_phn_date_to per_phones.date_to%TYPE; --Line added for bug# 878827

189: --
190: l_old_work_telephone per_phones.phone_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;

Line 225: from per_phones phn

221: select phone_number,
222: phone_id,
223: object_version_number,
224: date_to --Line added for bug# 878827
225: from per_phones phn
226: where phn.parent_id = p_person_id
227: and phn.parent_table = 'PER_ALL_PEOPLE_F'
228: and phn.phone_type = 'W1'
229: and p_effective_date between phn.date_from and