APPS.IGF_AW_AWD_CERT_RESPS_PKG dependencies on IGS_PE_HZ_PARTIES

Line 155: FROM igs_pe_hz_parties pe,

151: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
152: ) IS
153: SELECT pe.ROWID row_id,
154: pe.*
155: FROM igs_pe_hz_parties pe,
156: igf_ap_fa_base_rec_all fa
157: WHERE pe.party_id = fa.person_id
158: AND fa.base_id = cp_base_id;
159: l_pe_hz_parties c_pe_hz_parties%ROWTYPE;

Line 181: igs_pe_hz_parties_pkg.update_row(

177: OPEN c_pe_hz_parties(new_references.base_id);
178: FETCH c_pe_hz_parties INTO l_pe_hz_parties;
179: CLOSE c_pe_hz_parties;
180:
181: igs_pe_hz_parties_pkg.update_row(
182: x_rowid => l_pe_hz_parties.row_id,
183: x_party_id => l_pe_hz_parties.party_id,
184: x_deceased_ind => l_pe_hz_parties.deceased_ind,
185: x_archive_exclusion_ind => l_pe_hz_parties.archive_exclusion_ind,

Line 252: igs_pe_hz_parties_pkg.update_row(

248: OPEN c_pe_hz_parties(new_references.base_id);
249: FETCH c_pe_hz_parties INTO l_pe_hz_parties;
250: CLOSE c_pe_hz_parties;
251:
252: igs_pe_hz_parties_pkg.update_row(
253: x_rowid => l_pe_hz_parties.row_id,
254: x_party_id => l_pe_hz_parties.party_id,
255: x_deceased_ind => l_pe_hz_parties.deceased_ind,
256: x_archive_exclusion_ind => l_pe_hz_parties.archive_exclusion_ind,