APPS.IGS_EN_GEN_004 dependencies on IGS_PE_PERSON_ALIAS

Line 165: FROM IGS_PE_PERSON_ALIAS pal

161: WHERE ps.party_id = p_person_id ;
162:
163: CURSOR c_pal IS
164: SELECT 'x'
165: FROM IGS_PE_PERSON_ALIAS pal
166: WHERE pal.person_id = p_person_id AND
167: (pal.start_dt IS NULL OR
168: pal.start_dt <= p_effective_dt) AND
169: (pal.end_dt IS NULL OR

Line 241: -- check for the exsistence of a IGS_PE_PERSON alias record

237: END IF;
238: CLOSE c_ps;
239: END IF;
240: IF p_check_alias = TRUE THEN
241: -- check for the exsistence of a IGS_PE_PERSON alias record
242: OPEN c_pal;
243: FETCH c_pal INTO v_record_exists;
244: IF (c_pal%FOUND) THEN
245: p_alias_exists := TRUE;