APPS.IGS_PE_GEN_001 dependencies on HZ_PERSON_PROFILES

Line 121: hz_person_profiles pp

117: igs_en_gen_003.enrp_get_encmbrd_ind(p.party_id) encumbered_ind,
118: p.status status
119: FROM hz_parties p,
120: igs_pe_hz_parties pd,
121: hz_person_profiles pp
122: WHERE p.party_id = pp.party_id AND
123: p.party_id = pd.party_id (+) AND
124: sysdate between pp.effective_start_date AND
125: NVL(pp.effective_end_date,sysdate) AND

Line 157: p_person_name OUT NOCOPY hz_person_profiles.person_name%TYPE,

153: PROCEDURE get_hold_auth
154: (p_fnd_user_id IN fnd_user.user_id%TYPE,
155: p_person_id OUT NOCOPY hz_parties.party_id%TYPE,
156: p_person_number OUT NOCOPY hz_parties.party_number%TYPE,
157: p_person_name OUT NOCOPY hz_person_profiles.person_name%TYPE,
158: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE
159: ) IS
160: /*
161: || Created By : pkpatel

Line 252: l_person_name hz_person_profiles.person_name%TYPE;

248: hold_rec hold_cur%ROWTYPE;
249:
250: l_person_id hz_parties.party_id%TYPE;
251: l_person_number hz_parties.party_number%TYPE;
252: l_person_name hz_person_profiles.person_name%TYPE;
253: l_message_name fnd_new_messages.message_name%TYPE;
254:
255: BEGIN
256: