APPS.IGF_SL_GEN dependencies on IGS_PE_ALT_PERS_ID

Line 895: FROM igs_pe_alt_pers_id api,

891: SELECT api.api_person_id_uf ssn,
892: api.person_id_type,
893: api.start_dt,
894: api.end_dt
895: FROM igs_pe_alt_pers_id api,
896: igs_pe_person_id_typ pid
897: WHERE api.pe_person_id = cp_person_id
898: AND api.person_id_type = pid.person_id_type
899: AND pid.s_person_id_type = cp_person_id_type --

Line 983: FROM igs_pe_alt_pers_id api,

979: api.person_id_type,
980: api.start_dt,
981: api.end_dt,
982: pid.s_person_id_type
983: FROM igs_pe_alt_pers_id api,
984: igs_pe_person_id_typ pid
985: WHERE api.pe_person_id = cp_person_id
986: AND api.person_id_type = pid.person_id_type
987: AND pid.s_person_id_type = cp_person_id_type