APPS.IGS_EN_SPA_AWD_AIM_PKG dependencies on IGS_PE_PERSON_TYPES

Line 174: FROM igs_pe_person_types

170: pti.END_DATE IS NULL;
171:
172: CURSOR cur_pers_type(p_system_type varchar2) IS
173: SELECT PERSON_TYPE_CODE
174: FROM igs_pe_person_types
175: WHERE SYSTEM_TYPE = p_system_type AND
176: CLOSED_IND = 'N';
177:
178: -- Cursor used to fetch the Person Type Instance record which is being opened

Line 183: p_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE

179: -- irrespective of the system person type is closed or not.
180:
181: CURSOR cur_pe_typ_inst( p_person_id igs_pe_typ_instances.PERSON_ID%TYPE,
182: p_course_cd igs_pe_typ_instances.course_cd%TYPE,
183: p_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE
184: ) IS
185: SELECT pti.rowid row_id ,pti.*
186: FROM igs_pe_typ_instances_all pti,
187: igs_pe_person_types pty

Line 187: igs_pe_person_types pty

183: p_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE
184: ) IS
185: SELECT pti.rowid row_id ,pti.*
186: FROM igs_pe_typ_instances_all pti,
187: igs_pe_person_types pty
188: WHERE pti.person_id = p_person_id AND
189: pti.course_cd = p_course_cd AND
190: pti.end_date IS NULL AND
191: pty.person_type_code = pti.person_type_code AND

Line 197: p_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE,

193:
194: --Cursor to fecth Person Type Instance record with end date not null
195: CURSOR cur_per_typ_dt( p_person_id igs_pe_typ_instances.PERSON_ID%TYPE,
196: p_course_cd igs_pe_typ_instances.course_cd%TYPE,
197: p_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE,
198: p_date DATE ) IS
199: SELECT pti.rowid row_id ,pti.*
200: FROM igs_pe_typ_instances_all pti,
201: igs_pe_person_types pty

Line 201: igs_pe_person_types pty

197: p_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE,
198: p_date DATE ) IS
199: SELECT pti.rowid row_id ,pti.*
200: FROM igs_pe_typ_instances_all pti,
201: igs_pe_person_types pty
202: WHERE pti.person_id = p_person_id AND
203: pti.course_cd = p_course_cd AND
204: pti.end_date = p_date AND
205: pty.person_type_code = pti.person_type_code AND

Line 219: l_person_type igs_pe_person_types.PERSON_TYPE_CODE%TYPE;

215: cur_conf_dt_rec cur_conf_dt%ROWTYPE;
216: cur_pe_typ_inst_rec cur_pe_typ_inst%ROWTYPE;
217: cur_typ_id_inst_rec cur_typ_id_inst%ROWTYPE;
218: cur_per_typ_dt_rec cur_per_typ_dt%ROWTYPE;
219: l_person_type igs_pe_person_types.PERSON_TYPE_CODE%TYPE;
220: l_method igs_pe_typ_instances.CREATE_METHOD%TYPE;
221: l_TYPE_INSTANCE_ID igs_pe_typ_instances.TYPE_INSTANCE_ID%TYPE;
222: l_rowid VARCHAR2(25);
223: l_date DATE;