APPS.IGF_AP_BATCH_VER_PRC_PKG dependencies on HZ_PARTIES

Line 1433: hz_parties pe

1429: pe.person_last_name surname,
1430: im.isir_id
1431: FROM igf_ap_fa_base_rec_all far,
1432: igf_ap_isir_matched_all im,
1433: hz_parties pe
1434: WHERE far.person_id = pe.party_id
1435: AND far.ci_cal_type = NVL(lv_ci_cal_type,far.ci_cal_type)
1436: AND far.ci_sequence_number = NVL(lv_ci_sequence_number, far.ci_sequence_number)
1437: AND far.fed_verif_status IN ('SELECTED', 'NOTVERIFIED')

Line 1821: l_person_id hz_parties.party_id%TYPE;

1817: FROM igf_ap_fa_base_rec
1818: WHERE base_id = p_base_id;
1819:
1820: ln_count_open_items NUMBER;
1821: l_person_id hz_parties.party_id%TYPE;
1822: lv_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE;
1823: lv_fa_process_status igf_ap_fa_base_rec_all.fa_process_status%TYPE;
1824: ln_auto_na_complete VARCHAR2(80);
1825: