[Home] [Help]
105: Change History
106: Who When What
107: pkpatel 25-APR-2003 Bug 2908851
108: Tuned the cursors c_get_others and c_get_active. Removed the unnecessary join with
109: igs_lookups_view and changed igs_pe_typ_instances to igs_pe_typ_instances_all
110: pkpatel 4-MAY-2003 Bug 2989307
111: Removed the existence of active records for person types other than OTHER
112: (reverse chronological order - newest change first)
113: ***************************************************************/
239: Purpose :
240: Know limitations, enhancements or remarks
241: Change History
242: Who When What
243: pkpatel 20-sep-2004 Bug 3690856 (removed the cursor c_get_prospect since its not used. Removed igs_lookups_view join in th cursor c_get_applicant. Made cursors parameterized.
244: sykrishn IDOPA2 Commented part which prevents PROSPECT and STUDENT to coexist
245: (reverse chronological order - newest change first)
246: ***************************************************************/
247: CURSOR c_get_applicant(cp_system_type igs_pe_person_types.system_type%TYPE,
314: pathipat 17-JUL-2002 Added check for system person types with more than one mapping
315: for Bug No: 2464771
316: pkpatel 3-APR-2003 Bug No: 2859277
317: Closed the cursor person_type_cur in else condition.
318: asbala 12-SEP-03 Changed igs_lookups_view to igs_lookup_values in CURSOR meaning_cur
319: (reverse chronological order - newest change first)
320: ***************************************************************/
321:
322: CURSOR system_type_cur IS
329: FROM igs_pe_person_types pt
330: WHERE pt.system_type = cp_system_type AND
331: pt.closed_ind = cp_closed_ind;
332:
333: CURSOR meaning_cur(cp_system_type igs_lookup_values.lookup_code%TYPE,cp_lookup_type igs_lookups_view.lookup_type%TYPE) IS
334: SELECT meaning
335: FROM igs_lookup_values
336: WHERE lookup_code = cp_system_type AND
337: lookup_type = cp_lookup_type;