[Home] [Help]
19: | Build'; Bug# 2829291 |
20: | ijeddy 19-Jun-2003 Bug 2884615, addition of notified_date in |
21: | assp_ins_scap_lovall. |
22: | kdande 18-Aug-2003 Bug# 2895945. Changed the cursors to use |
23: | hz_parties table instead of igs_pe_person view. |
24: | smvk 09-Jul-2004 Bug # 3676145. Modified the cursors c_id_no_ind,|
25: | c_id_with_ind, c_surname_no_ind, c_sua_person_id,
26: | c_surname_with_ind, c_uop and c_sua_surname to |
27: | select active (not closed) unit classes. |
241: NULL n3,
242: NULL n4,
243: 'N'
244: FROM igs_as_msht_su_atmpt mssua,
245: hz_parties pe,
246: igs_en_su_attempt sua
247: WHERE mssua.sheet_number = p_sheet_number
248: AND pe.party_id = mssua.person_id
249: AND sua.person_id(+) = mssua.person_id
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,
360: igs_as_unit_class ucl
361: WHERE uoo.unit_cd = p_unit_cd
362: AND uoo.cal_type = p_cal_type
363: AND uoo.ci_sequence_number = TO_CHAR (p_sequence_number)
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,
388: igs_as_unit_class ucl
389: WHERE uoo.unit_cd = p_unit_cd
390: AND uoo.cal_type = p_cal_type
391: AND uoo.ci_sequence_number = TO_CHAR (p_sequence_number)
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,
423: igs_as_unit_class ucl
424: WHERE uoo.unit_cd = cp_unit_cd
425: AND uoo.cal_type = cp_cal_type
426: AND uoo.ci_sequence_number = TO_CHAR (cp_sequence_number)
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,
456: igs_as_unit_class ucl
457: WHERE uoo.unit_cd = cp_unit_cd
458: AND uoo.cal_type = cp_cal_type
459: AND uoo.ci_sequence_number = TO_CHAR (cp_sequence_number)
921: sua.unit_class,
922: unit_attempt_status
923: FROM igs_en_su_attempt sua,
924: igs_as_unit_class ucl,
925: hz_parties pe
926: WHERE sua.person_id = pe.party_id
927: AND ucl.unit_class = sua.unit_class
928: AND ucl.closed_ind = 'N'
929: AND sua.uoo_id = cp_uoo_id