DBA Data[Home] [Help]

APPS.IGS_HE_IMPORT_DATA dependencies on IGS_PE_PERSON_ID_TYP

Line 1121: CURSOR c_alt_persid_type( cp_persid_type igs_pe_person_id_typ.person_id_type%TYPE ) IS

1117: err.interface_hesa_id = NVL(cp_interface_id, err.interface_hesa_id);
1118: c_del_err_rec c_del_err%ROWTYPE ;
1119:
1120: -- check if person id type is setup
1121: CURSOR c_alt_persid_type( cp_persid_type igs_pe_person_id_typ.person_id_type%TYPE ) IS
1122: SELECT 'X'
1123: FROM igs_pe_person_id_typ
1124: WHERE person_id_type = cp_persid_type ;
1125:

Line 1123: FROM igs_pe_person_id_typ

1119:
1120: -- check if person id type is setup
1121: CURSOR c_alt_persid_type( cp_persid_type igs_pe_person_id_typ.person_id_type%TYPE ) IS
1122: SELECT 'X'
1123: FROM igs_pe_person_id_typ
1124: WHERE person_id_type = cp_persid_type ;
1125:
1126: -- Check if alternate id type HESA_INST for institution is setup
1127: CURSOR c_alt_orgid IS