APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_IMP_CONTACTS_INT

Line 56: FROM HZ_IMP_CONTACTS_INT INT

52: FROM HZ_IMP_CONTACTROLES_INT INT
53: WHERE INT.BATCH_ID = P_BATCH_ID AND
54: INT.CONTACT_ORIG_SYSTEM = P_ORIGINAL_SYSTEM ;
55: SELECT count(INT.BATCH_ID) into l_CONTACTS_IN_BATCH
56: FROM HZ_IMP_CONTACTS_INT INT
57: WHERE INT.BATCH_ID = P_BATCH_ID AND
58: INT.CONTACT_ORIG_SYSTEM = P_ORIGINAL_SYSTEM ;
59: SELECT count(INT.BATCH_ID) into l_CONTACTPOINTS_IN_BATCH
60: FROM HZ_IMP_CONTACTPTS_INT INT

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 415: and e.interface_table_name (+) = 'HZ_IMP_CONTACTS_INT'

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
414: and e.request_id (+) = p_request_id
415: and e.interface_table_name (+) = 'HZ_IMP_CONTACTS_INT'
416: and hoc.org_contact_id (+) = sg.contact_id
417: and hoc.request_id (+) = p_request_id
418: and sg.int_row_id = hzint.rowid (+)
419: and hzint.interface_status(+) = 'D'

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 834: FROM HZ_IMP_CONTACTS_INT INT

830: WHERE INT.BATCH_ID = P_BATCH_ID AND
831: INT.CONTACT_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
832: AND INT.INTERFACE_STATUS = 'R' ;
833: SELECT count(INT.BATCH_ID) into l_REMOVED_CONTACTS
834: FROM HZ_IMP_CONTACTS_INT INT
835: WHERE INT.BATCH_ID = P_BATCH_ID AND
836: INT.CONTACT_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
837: AND INT.INTERFACE_STATUS = 'R' ;
838: SELECT count(INT.BATCH_ID) into l_REMOVED_CONTACTPOINTS