DBA Data[Home] [Help]

APPS.HZ_DQM_DUP_ID_PKG dependencies on HZ_IMP_CONTACTPTS_INT

Line 664: from hz_imp_contactpts_int b

660: -- We take of the "CONTACT POINTS" entity here.
661: update hz_imp_int_dedup_results a
662: set (a.dup_creation_date, a.dup_last_update_date)
663: = (select b.creation_date, b.last_update_date
664: from hz_imp_contactpts_int b
665: where b.batch_id = p_batch_id
666: and b.cp_orig_system_reference = a.dup_record_osr
667: and b.cp_orig_system = a.dup_record_os
668: )

Line 1639: UPDATE HZ_IMP_CONTACTPTS_INT A

1635:
1636: ELSIF p_entity = 'CONTACT_POINTS'
1637: THEN
1638: FORALL I in H_POSR.FIRST..H_POSR.LAST
1639: UPDATE HZ_IMP_CONTACTPTS_INT A
1640: SET A.DQM_ACTION_FLAG = 'P'
1641: WHERE
1642: ( A.CP_ORIG_SYSTEM_REFERENCE = H_POSR(I) and
1643: A.CP_ORIG_SYSTEM = H_POS(I) and