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_SA_VALIDATE_PKG dependencies on PER_ALL_PEOPLE_F

Line 176: FROM per_all_people_f

172: ,p_per_information10 in varchar2 default null
173: ) IS
174: CURSOR csr_person_type_id IS
175: SELECT person_type_id
176: FROM per_all_people_f
177: WHERE person_id = p_person_id
178: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
179: l_person_type_id NUMBER;
180: BEGIN

Line 606: From per_all_people_f ppf , fnd_sessions fnd

602: l_valid_date2 varchar2(10);
603: l_nationality varchar2(30);
604: CURSOR csr_get_nationality (l_person_id number) IS
605: Select nationality
606: From per_all_people_f ppf , fnd_sessions fnd
607: Where ppf.person_id = l_person_id
608: and fnd.session_id = userenv('sessionid')
609: And fnd.effective_date between ppf.effective_start_date and ppf.effective_end_date;
610: BEGIN

Line 658: From per_all_people_f ppf , fnd_sessions fnd

654: From per_people_extra_info
655: Where person_extra_info_id = l_person_extra_info_id;
656: CURSOR csr_get_nationality (l_person_id number) IS
657: Select nationality
658: From per_all_people_f ppf , fnd_sessions fnd
659: Where ppf.person_id = l_person_id
660: and fnd.session_id = userenv('sessionid')
661: And fnd.effective_date between ppf.effective_start_date and ppf.effective_end_date;
662: BEGIN

Line 697: FROM per_all_people_f

693: l_annuities varchar2(40);
694: l_person_id number;
695: CURSOR csr_nationality IS
696: SELECT NATIONALITY
697: FROM per_all_people_f
698: WHERE person_id = l_person_id
699: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
700: BEGIN
701: