APPS.IGS_PE_ALT_PERS_ID_PKG dependencies on HZ_PARTIES

Line 149: CURSOR birth_date_cur(cp_person_id hz_parties.party_id%TYPE) IS

145: -- Validate Format Mask
146: ----------------------------------------------------------------------------------------------
147: v_message_name varchar2(30);
148:
149: CURSOR birth_date_cur(cp_person_id hz_parties.party_id%TYPE) IS
150: SELECT birth_date
151: FROM igs_pe_person_base_v
152: WHERE person_id = cp_person_id;
153:

Line 349: FROM igs_pe_alt_pers_id alt, hz_parties hz

345: closed_ind = 'N';
346:
347: CURSOR cptu IS
348: SELECT hz.party_number
349: FROM igs_pe_alt_pers_id alt, hz_parties hz
350: WHERE alt.person_id_type = new_references.person_id_type
351: AND alt.api_person_id = new_references.api_person_id
352: AND alt.pe_person_id <> new_references.pe_person_id
353: AND (alt.start_dt <> alt.end_dt OR alt.end_dt IS NULL)

Line 357: l_person_number hz_parties.party_number%TYPE;

353: AND (alt.start_dt <> alt.end_dt OR alt.end_dt IS NULL)
354: AND alt.pe_person_id = hz.party_id;
355:
356: lv_UniqueInd VARCHAR2(1);
357: l_person_number hz_parties.party_number%TYPE;
358:
359: BEGIN
360: FOR pt_rec IN pt LOOP
361: lv_UniqueInd := pt_rec.unique_ind;