APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_ORG_CONTACTS

Line 409: from hz_imp_tmp_errors e, hz_imp_contacts_sg sg, hz_org_contacts hoc, HZ_IMP_CONTACTS_INT hzint

405: and hzint.interface_status(+) = 'D'
406: union all
407: select /*+ full(sg) parallel(sg) */ nvl2(e.int_row_id,
408: 1, nvl2(NVL(hoc.org_contact_id,hzint.BATCH_ID),decode(sg.action_flag, 'I', 18, 19),24)) a
409: from hz_imp_tmp_errors e, hz_imp_contacts_sg sg, hz_org_contacts hoc, HZ_IMP_CONTACTS_INT hzint
410: where sg.batch_mode_flag = p_batch_mode_flag
411: and sg.batch_id = p_batch_id
412: and sg.contact_orig_system = p_original_system
413: and e.int_row_id (+) = sg.int_row_id