APPS.IGS_PE_TYP_INSTANCES_PKG dependencies on IGS_LOOKUP_VALUES

Line 318: asbala 12-SEP-03 Changed igs_lookups_view to igs_lookup_values in CURSOR meaning_cur

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

Line 333: CURSOR meaning_cur(cp_system_type igs_lookup_values.lookup_code%TYPE,cp_lookup_type igs_lookups_view.lookup_type%TYPE) 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;

Line 335: FROM igs_lookup_values

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;
338:
339: meaning_rec meaning_cur%ROWTYPE;

Line 712: FROM IGS_LOOKUP_VALUES

708:
709: CURSOR c_lookup_meaning(cp_lookup_type VARCHAR2,
710: cp_lookup_code VARCHAR2) IS
711: SELECT meaning
712: FROM IGS_LOOKUP_VALUES
713: WHERE lookup_type=cp_lookup_type AND
714: lookup_code=cp_lookup_code;
715:
716: CURSOR c_ar_lookups(cp_lookup_type VARCHAR2,