APPS.IGS_EN_OFR_WLST_OPT dependencies on IGS_PE_PERSON_TYPES

Line 117: FROM igs_pe_person_types

113:
114: -- cursor to get person type
115: CURSOR cur_per_typ IS
116: SELECT person_type_code
117: FROM igs_pe_person_types
118: WHERE system_type = 'OTHER';
119: l_cur_per_typ cur_per_typ%ROWTYPE;
120: lv_person_type igs_pe_person_types.person_type_code%TYPE;
121:

Line 120: lv_person_type igs_pe_person_types.person_type_code%TYPE;

116: SELECT person_type_code
117: FROM igs_pe_person_types
118: WHERE system_type = 'OTHER';
119: l_cur_per_typ cur_per_typ%ROWTYPE;
120: lv_person_type igs_pe_person_types.person_type_code%TYPE;
121:
122: -- cursor tp get system person type
123: CURSOR cur_sys_pers_type(cp_person_type_code VARCHAR2) IS
124: SELECT system_type

Line 125: FROM igs_pe_person_types

121:
122: -- cursor tp get system person type
123: CURSOR cur_sys_pers_type(cp_person_type_code VARCHAR2) IS
124: SELECT system_type
125: FROM igs_pe_person_types
126: WHERE person_type_code = cp_person_type_code;
127:
128: l_sys_per_type igs_pe_person_types.system_type%TYPE;
129:

Line 128: l_sys_per_type igs_pe_person_types.system_type%TYPE;

124: SELECT system_type
125: FROM igs_pe_person_types
126: WHERE person_type_code = cp_person_type_code;
127:
128: l_sys_per_type igs_pe_person_types.system_type%TYPE;
129:
130: BEGIN
131: IGS_GE_MSG_STACK.INITIALIZE;
132: --fetch the person id corresponding to person number passed as parameter