DBA Data[Home] [Help]

APPS.HR_SA_VALIDATE_PKG dependencies on FND_SESSIONS

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