APPS.IGS_PE_SET_REM_HOLDS dependencies on HZ_PARTIES

Line 140: l_person_id hz_parties.party_id%TYPE;

136: l_err_raised BOOLEAN := FALSE;
137: l_resp_id fnd_responsibility.responsibility_id%TYPE := FND_GLOBAL.RESP_ID;
138:
139: l_error_exception EXCEPTION ; /* user defined exception */
140: l_person_id hz_parties.party_id%TYPE;
141: l_person_number hz_parties.party_number%TYPE;
142: l_person_name hz_person_profiles.person_name%TYPE;
143:
144: L_select VARCHAR2(32767) := 'SELECT p.person_id,p.person_number,p.full_name FROM igs_pe_person_base_v p WHERE p.person_id IN ';

Line 141: l_person_number hz_parties.party_number%TYPE;

137: l_resp_id fnd_responsibility.responsibility_id%TYPE := FND_GLOBAL.RESP_ID;
138:
139: l_error_exception EXCEPTION ; /* user defined exception */
140: l_person_id hz_parties.party_id%TYPE;
141: l_person_number hz_parties.party_number%TYPE;
142: l_person_name hz_person_profiles.person_name%TYPE;
143:
144: L_select VARCHAR2(32767) := 'SELECT p.person_id,p.person_number,p.full_name FROM igs_pe_person_base_v p WHERE p.person_id IN ';
145: TYPE cur_query IS REF CURSOR;

Line 391: l_person_id hz_parties.party_id%TYPE;

387: l_err_raised BOOLEAN := FALSE;
388:
389: l_resp_id fnd_responsibility.responsibility_id%TYPE := FND_GLOBAL.RESP_ID;
390: l_fnd_user_id fnd_user.user_id%TYPE := FND_GLOBAL.USER_ID;
391: l_person_id hz_parties.party_id%TYPE;
392: l_person_number hz_parties.party_number%TYPE;
393: l_person_name hz_person_profiles.person_name%TYPE;
394:
395:

Line 392: l_person_number hz_parties.party_number%TYPE;

388:
389: l_resp_id fnd_responsibility.responsibility_id%TYPE := FND_GLOBAL.RESP_ID;
390: l_fnd_user_id fnd_user.user_id%TYPE := FND_GLOBAL.USER_ID;
391: l_person_id hz_parties.party_id%TYPE;
392: l_person_number hz_parties.party_number%TYPE;
393: l_person_name hz_person_profiles.person_name%TYPE;
394:
395:
396: -- cursor selects row_id from igs_pe_pers_encumb table based on person id and hold type