APPS.HZ_DQM_DUP_ID_PKG dependencies on HZ_IMP_PARTIES_INT

Line 1571: UPDATE HZ_IMP_PARTIES_INT A

1567:
1568: BEGIN
1569: -- update the interface table
1570: FORALL I in H_POSR.FIRST..H_POSR.LAST
1571: UPDATE HZ_IMP_PARTIES_INT A
1572: SET A.DQM_ACTION_FLAG = DECODE(H_AM_FLAG(I), 'Y','D','P')
1573: WHERE
1574: ( A.PARTY_ORIG_SYSTEM_REFERENCE = H_POSR(I) and
1575: A.PARTY_ORIG_SYSTEM = H_POS(I) and

Line 1921: from hz_imp_parties_int b

1917: -- We take of the "PARTY" entity here.
1918: update hz_imp_int_dedup_results a
1919: set (a.dup_creation_date, a.dup_last_update_date)
1920: = (select b.creation_date, b.last_update_date
1921: from hz_imp_parties_int b
1922: where b.batch_id = p_batch_id
1923: and b.party_orig_system_reference = a.dup_record_osr
1924: and b.party_orig_system = a.dup_record_os
1925: )

Line 1939: from hz_imp_parties_int b

1935: where a.entity = 'PARTY'
1936: and a.batch_id = p_batch_id
1937: and not exists
1938: ( select 1
1939: from hz_imp_parties_int b
1940: where a.batch_id = b.batch_id
1941: and a.winner_record_osr = b.party_orig_system_reference
1942: and a.winner_record_os = b.party_orig_system
1943: );