APPS.PAY_DK_ARCHIVE_EHOL dependencies on PER_PEOPLE_EXTRA_INFO

Line 1165: SELECT PEI_INFORMATION1 yes_no FROM per_people_extra_info

1161: rg_csr_latest_hire_date csr_latest_hire_date%rowtype;
1162:
1163: /* Cursor to get the extra person info - Foreigner (yes/no) */
1164: CURSOR csr_get_extra_person_info(pid per_all_people_f.person_id%type) IS
1165: SELECT PEI_INFORMATION1 yes_no FROM per_people_extra_info
1166: WHERE person_id=pid
1167: AND information_type='DK_EINCOME_FORIEGN_IND';
1168:
1169: rg_csr_get_extra_person_info csr_get_extra_person_info%rowtype;