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 179: FROM per_all_people_f

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

Line 609: From per_all_people_f ppf , fnd_sessions fnd

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

Line 661: From per_all_people_f ppf , fnd_sessions fnd

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

Line 700: FROM per_all_people_f

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