APPS.IGS_EN_SUA_API dependencies on IGS_PE_PERSON_TYPES

Line 1156: FROM igs_pe_person_types

1152:
1153: -- cursor to get person type
1154: CURSOR cur_per_typ IS
1155: SELECT person_type_code
1156: FROM igs_pe_person_types
1157: WHERE system_type = 'OTHER';
1158: l_cur_per_typ cur_per_typ%ROWTYPE;
1159: lv_person_type igs_pe_person_types.person_type_code%TYPE;
1160:

Line 1159: lv_person_type igs_pe_person_types.person_type_code%TYPE;

1155: SELECT person_type_code
1156: FROM igs_pe_person_types
1157: WHERE system_type = 'OTHER';
1158: l_cur_per_typ cur_per_typ%ROWTYPE;
1159: lv_person_type igs_pe_person_types.person_type_code%TYPE;
1160:
1161: -- cursor tp get system person type
1162: CURSOR cur_sys_pers_type(cp_person_type_code VARCHAR2) IS
1163: SELECT system_type

Line 1164: FROM igs_pe_person_types

1160:
1161: -- cursor tp get system person type
1162: CURSOR cur_sys_pers_type(cp_person_type_code VARCHAR2) IS
1163: SELECT system_type
1164: FROM igs_pe_person_types
1165: WHERE person_type_code = cp_person_type_code;
1166:
1167: l_sys_per_type igs_pe_person_types.system_type%TYPE;
1168:

Line 1167: l_sys_per_type igs_pe_person_types.system_type%TYPE;

1163: SELECT system_type
1164: FROM igs_pe_person_types
1165: WHERE person_type_code = cp_person_type_code;
1166:
1167: l_sys_per_type igs_pe_person_types.system_type%TYPE;
1168:
1169: -- added for bug 3526251
1170: NO_AUSL_RECORD_FOUND EXCEPTION;
1171: PRAGMA EXCEPTION_INIT(NO_AUSL_RECORD_FOUND , -20010);