APPS.IGS_HE_IMPORT_POPDLHE dependencies on IGS_PE_ALT_PERS_ID

Line 566: FROM igs_pe_alt_pers_id

562:
563: -- Determines PersonID from alternateID table using HUSID
564: CURSOR c_husid (cp_husid igs_he_popdlhe_ints.husid%TYPE) IS
565: SELECT pe_person_id
566: FROM igs_pe_alt_pers_id
567: WHERE api_person_id = cp_husid
568: AND person_id_type= 'HUSID'
569: AND (end_dt IS NULL OR start_dt <> end_dt)
570: ORDER BY start_dt DESC;