APPS.IGS_AS_GEN_004 dependencies on IGS_GE_GEN_002

Line 355: igs_ge_gen_002.genp_get_initials (pe.person_first_name),

351: sua.person_id,
352: sua.course_cd,
353: sua.unit_attempt_status,
354: pe.person_last_name surname,
355: igs_ge_gen_002.genp_get_initials (pe.person_first_name),
356: sua.version_number
357: FROM igs_ps_unit_ofr_opt uoo,
358: igs_en_su_attempt sua,
359: hz_parties pe,

Line 383: igs_ge_gen_002.genp_get_initials (pe.person_first_name),

379: sua.person_id,
380: sua.course_cd,
381: sua.unit_attempt_status,
382: pe.person_last_name surname,
383: igs_ge_gen_002.genp_get_initials (pe.person_first_name),
384: sua.version_number
385: FROM igs_ps_unit_ofr_opt uoo,
386: igs_en_su_attempt sua,
387: hz_parties pe,

Line 418: igs_ge_gen_002.genp_get_initials (pe.person_first_name),

414: sua.person_id,
415: sua.course_cd,
416: sua.unit_attempt_status,
417: pe.person_last_name surname,
418: igs_ge_gen_002.genp_get_initials (pe.person_first_name),
419: sua.version_number
420: FROM igs_ps_unit_ofr_opt uoo,
421: igs_en_su_attempt sua,
422: hz_parties pe,

Line 451: igs_ge_gen_002.genp_get_initials (pe.person_first_name),

447: sua.person_id,
448: sua.course_cd,
449: sua.unit_attempt_status,
450: pe.person_last_name surname,
451: igs_ge_gen_002.genp_get_initials (pe.person_first_name),
452: sua.version_number
453: FROM igs_ps_unit_ofr_opt uoo,
454: igs_en_su_attempt sua,
455: hz_parties pe,