APPS.IGS_PE_PER_TYPE_MAP_PKG dependencies on IGS_PE_TYP_INSTANCES

Line 252: FROM igs_pe_typ_instances_all ti,

248: */
249:
250: CURSOR person_type_cur(cp_system_type igs_pe_person_types.system_type%TYPE) IS
251: SELECT ti.rowid,ti.*
252: FROM igs_pe_typ_instances_all ti,
253: igs_pe_person_types pt,
254: per_all_people_f ppf
255: WHERE ppf.party_id = ti.person_id AND
256: ti.person_type_code = pt.person_type_code AND

Line 263: FROM igs_pe_typ_instances

259: ;
260: --skpandey, Bug#4937960: Changed staff_exist cursor definition to optimize query
261: CURSOR staff_exist (cp_person_id HZ_PARTIES.PARTY_ID%TYPE) IS
262: SELECT '1'
263: FROM igs_pe_typ_instances
264: WHERE person_id = cp_person_id
265: AND system_type = 'STAFF'
266: AND (end_date IS NULL OR (SYSDATE BETWEEN start_date AND end_date));
267:

Line 271: FROM igs_pe_typ_instances_all ti,

267:
268:
269: CURSOR ss_cur (cp_person_id HZ_PARTIES.PARTY_ID%TYPE) IS
270: SELECT ti.rowid,ti.*
271: FROM igs_pe_typ_instances_all ti,
272: igs_pe_person_types pt
273: WHERE ti.person_type_code = pt.person_type_code AND
274: pt.system_type = 'SS_ENROLL_STAFF' AND
275: ti.person_id = cp_person_id;

Line 290: igs_pe_typ_instances_pkg.update_row

286: LOOP
287: FETCH person_type_cur into person_type_rec;
288: EXIT WHEN person_type_cur%NOTFOUND;
289:
290: igs_pe_typ_instances_pkg.update_row
291: (
292: x_rowid => person_type_rec.rowid,
293: x_person_id => person_type_rec.person_id,
294: x_course_cd => person_type_rec.course_cd,

Line 325: igs_pe_typ_instances_pkg.update_row

321:
322: FETCH ss_cur INTO ss_rec;
323: EXIT WHEN ss_cur%NOTFOUND;
324:
325: igs_pe_typ_instances_pkg.update_row
326: (
327: x_rowid => ss_rec.rowid,
328: x_person_id => ss_rec.person_id,
329: x_course_cd => ss_rec.course_cd,