APPS.IGS_FI_AD_HOC_WAV dependencies on HZ_PARTIES

Line 246: TYPE tab_party_rec IS TABLE OF hz_parties.party_id%TYPE INDEX BY BINARY_INTEGER;

242: l_fee_ci_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE ;
243: l_per_num igs_pe_person_v.person_number%TYPE ;
244: l_msg_str VARCHAR2(1000) ;
245:
246: TYPE tab_party_rec IS TABLE OF hz_parties.party_id%TYPE INDEX BY BINARY_INTEGER;
247: v_tab_party_rec tab_party_rec ;
248: l_n_party_id hz_parties.party_id%TYPE;
249:
250:

Line 248: l_n_party_id hz_parties.party_id%TYPE;

244: l_msg_str VARCHAR2(1000) ;
245:
246: TYPE tab_party_rec IS TABLE OF hz_parties.party_id%TYPE INDEX BY BINARY_INTEGER;
247: v_tab_party_rec tab_party_rec ;
248: l_n_party_id hz_parties.party_id%TYPE;
249:
250:
251:
252: CURSOR c_grp_id (cp_group_id igs_pe_persid_group_v.group_id%TYPE) IS

Line 261: CURSOR c_per_id (cp_n_person_id hz_parties.party_id%TYPE) IS

257: AND TRUNC(create_dt) <= TRUNC(SYSDATE);
258:
259: l_v_grp_id VARCHAR2(1);
260:
261: CURSOR c_per_id (cp_n_person_id hz_parties.party_id%TYPE) IS
262: SELECT hz.party_number person_number,
263: nvl(pp.person_name, hz.party_name) full_name
264: FROM hz_parties hz, hz_person_profiles pp
265: WHERE hz.party_id = cp_n_person_id

Line 264: FROM hz_parties hz, hz_person_profiles pp

260:
261: CURSOR c_per_id (cp_n_person_id hz_parties.party_id%TYPE) IS
262: SELECT hz.party_number person_number,
263: nvl(pp.person_name, hz.party_name) full_name
264: FROM hz_parties hz, hz_person_profiles pp
265: WHERE hz.party_id = cp_n_person_id
266: AND pp.party_id = cp_n_person_id;
267:
268: l_v_per_id c_per_id%ROWTYPE;

Line 292: CURSOR c_person(cp_person_id hz_parties.party_id%TYPE) IS

288: AND (start_date <= TRUNC(SYSDATE) OR start_date IS NULL)
289: AND (end_date >= TRUNC(SYSDATE) OR end_date IS NULL)
290: ORDER BY 1;
291:
292: CURSOR c_person(cp_person_id hz_parties.party_id%TYPE) IS
293: SELECT party_id person_id
294: FROM hz_parties
295: WHERE party_id = cp_person_id
296: AND party_type IN ('ORGANIZATION','PERSON');

Line 294: FROM hz_parties

290: ORDER BY 1;
291:
292: CURSOR c_person(cp_person_id hz_parties.party_id%TYPE) IS
293: SELECT party_id person_id
294: FROM hz_parties
295: WHERE party_id = cp_person_id
296: AND party_type IN ('ORGANIZATION','PERSON');
297:
298: CURSOR c_per_chg (cp_person_id igs_pe_person_v.person_id%TYPE ,