APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_IMP_CONTACTS_SG

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

Line 697: FROM HZ_IMP_CONTACTS_INT INT, HZ_IMP_CONTACTS_SG SG

693: INT.SUB_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
694: AND INT.ACTION_FLAG = 'I' ;
695: -- for l_NEW_UNIQUE_CONTACTS
696: SELECT count(INT.BATCH_ID) into l_NEW_UNIQUE_CONTACTS
697: FROM HZ_IMP_CONTACTS_INT INT, HZ_IMP_CONTACTS_SG SG
698: WHERE INT.BATCH_ID = P_BATCH_ID AND
699: INT.SUB_ORIG_SYSTEM = P_ORIGINAL_SYSTEM AND
700: INT.BATCH_ID = SG.BATCH_ID AND
701: INT.SUB_ORIG_SYSTEM = SG.SUB_ORIG_SYSTEM AND

Line 773: FROM HZ_IMP_CONTACTS_SG INT

769: INT.SUB_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
770: AND INT.ACTION_FLAG = 'U' ;
771: -- for l_EXISTING_CONTACTS
772: SELECT count(INT.BATCH_ID) into l_EXISTING_CONTACTS
773: FROM HZ_IMP_CONTACTS_SG INT
774: WHERE INT.BATCH_ID = P_BATCH_ID AND
775: INT.CONTACT_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
776: AND INT.ACTION_FLAG = 'U' ;
777: -- for l_EXISTING_CONTACTPOINTS