APPS.IGS_AD_IMP_008 dependencies on IGS_PE_STAT_DETAILS

Line 4226: -- felxfield in IGS_PE_STAT_DETAILS table as a part of bug 2203778

4222: IF l_success = 'Y' THEN
4223:
4224: --Bayadav :Changed the columns values getting passed for attribute1 to attribute20 from null
4225: --to new flexfield columns added in iGS_AD_STAT_INT table to pass these flexfields values in newly added
4226: -- felxfield in IGS_PE_STAT_DETAILS table as a part of bug 2203778
4227:
4228: igs_pe_stat_pkg.insert_row(
4229: X_ACTION=> 'INSERT',
4230: X_ROWID=> l_rowid,

Line 4479: igs_pe_stat_details sd,

4475: AND mi.match_ind IS NULL
4476: AND mi.status = '2'
4477: AND EXISTS ( SELECT 1
4478: FROM hz_person_profiles pp,
4479: igs_pe_stat_details sd,
4480: igs_ad_interface_all ii
4481: WHERE ii.interface_run_id = l_interface_run_id AND
4482: ii.interface_id = mi.interface_id AND
4483: ii.person_id = pp.party_id AND

Line 4615: igs_pe_stat_details sd,

4611: pp.content_source_number,
4612: p.object_version_number object_version_number
4613: FROM
4614: hz_person_profiles pp,
4615: igs_pe_stat_details sd,
4616: hz_parties p
4617: WHERE
4618: sd.person_id(+) = p.party_id AND
4619: pp.party_id = p.party_id AND