APPS.IGS_EN_SPA_AWD_AIM_PKG dependencies on IGS_PE_TYP_INSTANCES_ALL

Line 166: FROM igs_pe_typ_instances_all pti

162:
163: -- Cursor to fetch active Person Type Instance Record
164: CURSOR cur_typ_id_inst(p_PERSON_ID NUMBER,p_COURSE_CD VARCHAR2,p_PERSON_TYPE_CODE VARCHAR2) IS
165: SELECT pti.*
166: FROM igs_pe_typ_instances_all pti
167: WHERE pti.PERSON_ID = p_PERSON_ID AND
168: pti.COURSE_CD = p_COURSE_CD AND
169: pti.PERSON_TYPE_CODE = p_PERSON_TYPE_CODE AND
170: pti.END_DATE IS NULL;

Line 186: FROM igs_pe_typ_instances_all pti,

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
188: WHERE pti.person_id = p_person_id AND
189: pti.course_cd = p_course_cd AND
190: pti.end_date IS NULL AND

Line 200: FROM igs_pe_typ_instances_all pti,

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
202: WHERE pti.person_id = p_person_id AND
203: pti.course_cd = p_course_cd AND
204: pti.end_date = p_date AND