APPS.HZ_DQM_DUP_ID_PKG dependencies on HZ_IMP_ADDRESSES_INT

Line 642: from hz_imp_addresses_int b

638: -- We take of the "PARTY SITES" entity here.
639: update hz_imp_int_dedup_results a
640: set (a.dup_creation_date, a.dup_last_update_date)
641: = (select b.creation_date, b.last_update_date
642: from hz_imp_addresses_int b
643: where b.batch_id = p_batch_id
644: and b.site_orig_system_reference = a.dup_record_osr
645: and b.site_orig_system = a.dup_record_os
646: )

Line 1628: UPDATE HZ_IMP_ADDRESSES_INT A

1624: -- update the corresponding detail interface table
1625: IF p_entity = 'PARTY_SITES'
1626: THEN
1627: FORALL I in H_POSR.FIRST..H_POSR.LAST
1628: UPDATE HZ_IMP_ADDRESSES_INT A
1629: SET A.DQM_ACTION_FLAG = 'P'
1630: WHERE
1631: ( A.SITE_ORIG_SYSTEM_REFERENCE = H_POSR(I) and
1632: A.SITE_ORIG_SYSTEM = H_POS(I) and