APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_IMP_ADDRESSES_SG

Line 346: from hz_imp_tmp_errors e, hz_imp_addresses_sg sg,hz_party_sites hps,

342: and hzint.interface_status(+) = 'D'
343: union all
344: select /*+ full(sg) parallel(sg) */ nvl2(e.int_row_id,
345: 1, nvl2(NVL(loc.location_id,hzint.BATCH_ID),decode(sg.action_flag, 'I', 10, 11),24)) a
346: from hz_imp_tmp_errors e, hz_imp_addresses_sg sg,hz_party_sites hps,
347: hz_orig_sys_references hosr,hz_locations loc, HZ_IMP_ADDRESSES_INT hzint
348: where sg.batch_mode_flag = p_batch_mode_flag
349: and sg.batch_id = p_batch_id
350: and sg.party_orig_system = p_original_system

Line 664: FROM HZ_IMP_ADDRESSES_INT INT, HZ_IMP_ADDRESSES_SG SG

660: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
661: AND INT.ACTION_FLAG = 'I' ;
662: -- for l_NEW_UNIQUE_ADDRESSES
663: SELECT count(INT.BATCH_ID) into l_NEW_UNIQUE_ADDRESSES
664: FROM HZ_IMP_ADDRESSES_INT INT, HZ_IMP_ADDRESSES_SG SG
665: WHERE INT.BATCH_ID = P_BATCH_ID AND
666: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM AND
667: INT.BATCH_ID = SG.BATCH_ID AND
668: INT.PARTY_ORIG_SYSTEM = SG.PARTY_ORIG_SYSTEM AND

Line 743: FROM HZ_IMP_ADDRESSES_SG INT

739: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
740: AND INT.ACTION_FLAG = 'U' ;
741: -- for l_EXISTING_ADDRESSES
742: SELECT count(INT.BATCH_ID) into l_EXISTING_ADDRESSES
743: FROM HZ_IMP_ADDRESSES_SG INT
744: WHERE INT.BATCH_ID = P_BATCH_ID AND
745: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
746: AND INT.ACTION_FLAG = 'U' ;
747: -- for l_EXISTING_FINNUMBERS