APPS.IGS_ST_GEN_004 dependencies on IGS_PE_PERSON_ID_TYP

Line 493: IGS_PE_PERSON_ID_TYP pit

489: cp_person_id IGS_PE_PERSON.person_id%TYPE,
490: cp_eff_dt DATE) IS
491: SELECT api.pe_person_id
492: FROM IGS_PE_ALT_PERS_ID api,
493: IGS_PE_PERSON_ID_TYP pit
494: WHERE api.api_person_id = TO_CHAR(cp_person_id) AND
495: pit.person_id_type = api.person_id_type AND
496: pit.s_person_id_type = 'OBSOLETE' AND
497: api.start_dt IS NOT NULL AND