APPS.IGS_FI_GEN_007 dependencies on IGS_PE_PERSON

Line 1159: FUNCTION validate_person(p_person_id igs_pe_person.person_id%TYPE) RETURN VARCHAR2 IS

1155: END IF;
1156:
1157: END create_application;
1158:
1159: FUNCTION validate_person(p_person_id igs_pe_person.person_id%TYPE) RETURN VARCHAR2 IS
1160: /*|| Created By :Sarakshi
1161: || Created On :27-Feb-2002
1162: || Purpose : For validating the input person_id, for the person_type of PERSON,ORGANIZATION.
1163: || If record is found in igs_fi_parties_v then it returns 'Y'else 'N'.

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;