APPS.IGS_FI_GEN_007 dependencies on IGS_PE_PERSON_ID_TYP

Line 1238: || from igs_pe_person_id_typ instead of the igs_pe_person_id_typ_v.

1234: || Known limitations, enhancements or remarks :
1235: || Change History :
1236: || Who When What
1237: || smadathi 01-jan-2003 Bug 2713272. Modified the cursor cur_pref_person to select
1238: || from igs_pe_person_id_typ instead of the igs_pe_person_id_typ_v.
1239: || This is done due to Non-Meargabile view and higher value of shared memory
1240: || beyong the acceptable limit
1241: || (reverse chronological order - newest change first) */
1242: CURSOR cur_pref_person IS

Line 1244: FROM igs_pe_person_id_typ

1240: || beyong the acceptable limit
1241: || (reverse chronological order - newest change first) */
1242: CURSOR cur_pref_person IS
1243: SELECT person_id_type
1244: FROM igs_pe_person_id_typ
1245: WHERE preferred_ind='Y';
1246: l_person_id_type igs_pe_person_id_typ.person_id_type%TYPE;
1247: BEGIN
1248: OPEN cur_pref_person;

Line 1246: l_person_id_type igs_pe_person_id_typ.person_id_type%TYPE;

1242: CURSOR cur_pref_person IS
1243: SELECT person_id_type
1244: FROM igs_pe_person_id_typ
1245: WHERE preferred_ind='Y';
1246: l_person_id_type igs_pe_person_id_typ.person_id_type%TYPE;
1247: BEGIN
1248: OPEN cur_pref_person;
1249: FETCH cur_pref_person INTO l_person_id_type;
1250: CLOSE cur_pref_person;