APPS.HZ_BATCH_ACTION_PUB dependencies on HZ_IMP_DUP_DETAILS

Line 1638: FROM HZ_IMP_DUP_DETAILS

1634: WHERE batch_id = p_batch_id
1635: AND ENTITY = p_entity
1636: UNION
1637: SELECT record_os,record_osr
1638: FROM HZ_IMP_DUP_DETAILS
1639: WHERE batch_id= p_batch_id
1640: AND entity= p_entity
1641: ;
1642:

Line 2582: DELETE FROM HZ_IMP_DUP_DETAILS

2578: (p_action_pot_dup_addrs = 'REMOVE' or p_action_pot_dup_addrs = 'INSERT' ) )
2579: THEN
2580:
2581: FORALL i in l_site_orig_osr.FIRST..l_site_orig_osr.LAST
2582: DELETE FROM HZ_IMP_DUP_DETAILS
2583: WHERE batch_id = p_batch_id
2584: AND record_os = l_site_orig_os(i)
2585: AND record_osr = l_site_orig_osr(i) ;
2586:

Line 2675: DELETE FROM HZ_IMP_DUP_DETAILS

2671: (p_action_pot_dup_contacts = 'REMOVE' or p_action_pot_dup_contacts = 'INSERT' ) )
2672: THEN
2673:
2674: FORALL i in l_cont_orig_osr.FIRST..l_cont_orig_osr.LAST
2675: DELETE FROM HZ_IMP_DUP_DETAILS
2676: WHERE batch_id = p_batch_id
2677: AND record_os = l_cont_orig_os(i)
2678: AND record_osr = l_cont_orig_osr(i) ;
2679:

Line 2760: DELETE FROM HZ_IMP_DUP_DETAILS

2756: (p_action_pot_dup_cpts = 'REMOVE' or p_action_pot_dup_cpts = 'INSERT' ) )
2757: THEN
2758:
2759: FORALL i in l_cpts_orig_osr.FIRST..l_cpts_orig_osr.LAST
2760: DELETE FROM HZ_IMP_DUP_DETAILS
2761: WHERE batch_id = p_batch_id
2762: AND record_os = l_cpts_orig_os(i)
2763: AND record_osr = l_cpts_orig_osr(i) ;
2764: