APPS.PAY_DK_ARCHIVE_EIN dependencies on PER_PEOPLE_EXTRA_INFO

Line 898: SELECT PEI_INFORMATION1 yes_no ,PEI_INFORMATION2 stationed_abroad FROM per_people_extra_info

894: rg_csr_latest_hire_date csr_latest_hire_date%rowtype;
895:
896: /* Cursor to get the extra person info - Foreigner (yes/no) */ -- bug 13880339
897: CURSOR csr_get_extra_person_info(pid per_all_people_f.person_id%type) IS
898: SELECT PEI_INFORMATION1 yes_no ,PEI_INFORMATION2 stationed_abroad FROM per_people_extra_info
899: WHERE person_id=pid
900: AND information_type='DK_EINCOME_FORIEGN_IND';
901:
902: rg_csr_get_extra_person_info csr_get_extra_person_info%rowtype;