eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_BATCH_ACTION_PUB dependencies on HZ_IMP_DUP_PARTIES

Line 1627: FROM HZ_IMP_DUP_PARTIES

1623: WHERE batch_id = p_batch_id
1624: AND ENTITY = p_entity
1625: UNION
1626: SELECT party_osr,party_os
1627: FROM HZ_IMP_DUP_PARTIES
1628: WHERE batch_id= p_batch_id
1629: ;
1630:
1631: Cursor select_detail_rec(p_batch_id IN NUMBER ,p_entity IN VARCHAR2 ) is

Line 2401: UPDATE HZ_IMP_DUP_PARTIES

2397: (p_action_pot_dup_parties = 'REMOVE' or p_action_pot_dup_parties = 'INSERT' ) )
2398: THEN
2399:
2400: FORALL i in l_party_orig_osr.FIRST..l_party_orig_osr.LAST
2401: UPDATE HZ_IMP_DUP_PARTIES
2402: SET auto_merge_flag = 'R'
2403: WHERE batch_id = p_batch_id
2404: AND party_id = l_party_id(i)
2405: AND party_os = l_party_orig_os(i)

Line 2500: UPDATE HZ_IMP_DUP_PARTIES

2496: AND party_orig_system_reference = l_party_orig_osr(i) ;
2497:
2498:
2499: FORALL i in l_party_orig_osr.FIRST..l_party_orig_osr.LAST
2500: UPDATE HZ_IMP_DUP_PARTIES
2501: SET auto_merge_flag = 'N'
2502: WHERE batch_id = p_batch_id
2503: AND party_id = l_party_id(i)
2504: AND party_os = l_party_orig_os(i)