APPS.IGF_AP_LG_TD_IMP dependencies on HZ_PARTIES

Line 196: lv_person_id igs_pe_hz_parties.party_id%TYPE := NULL;

192: l_terminate_flag BOOLEAN := FALSE;
193: l_error_flag BOOLEAN := FALSE;
194: l_error VARCHAR2(10);
195: lv_row_id VARCHAR2(80) := NULL;
196: lv_person_id igs_pe_hz_parties.party_id%TYPE := NULL;
197: lv_base_id igf_ap_fa_base_rec_all.base_id%TYPE := NULL;
198: l_old_person_number igf_ap_li_todo_ints.person_number%TYPE := '******';
199: l_current_person_number igf_ap_li_todo_ints.person_number%TYPE := NULL;
200: l_person_skip_flag BOOLEAN := FALSE;

Line 272: hz_parties hz

268: cp_person_number VARCHAR2)
269: IS
270: SELECT hz.party_number person_id
271: FROM igs_co_interac_hist hist,
272: hz_parties hz
273: WHERE hist.cal_type = cp_cal_type
274: AND hist.ci_sequence_number = cp_seq_number
275: AND hist.student_id = hz.party_id
276: AND hz.party_number = cp_person_number

Line 827: l_person_id hz_parties.party_id%TYPE;

823: FROM igf_ap_fa_base_rec
824: WHERE base_id = cp_base_id;
825:
826: ln_count_open_items NUMBER;
827: l_person_id hz_parties.party_id%TYPE;
828: lv_fa_process_status igf_ap_fa_base_rec_all.fa_process_status%TYPE;
829: ln_auto_na_complete VARCHAR2(80);
830:
831: BEGIN