APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_IMP_ADDRESSUSES_SG

Line 395: from hz_imp_tmp_errors e, hz_imp_addressuses_sg sg, hz_party_site_uses hpsu, HZ_IMP_ADDRESSUSES_INT hzint

391: and hzint.interface_status(+) = 'D'
392: union all
393: select /*+ full(sg) parallel(sg) */ nvl2(e.int_row_id,
394: 1, nvl2(NVL(hpsu.party_site_use_id,hzint.BATCH_ID),decode(sg.action_flag, 'I', 16, 17),24)) a
395: from hz_imp_tmp_errors e, hz_imp_addressuses_sg sg, hz_party_site_uses hpsu, HZ_IMP_ADDRESSUSES_INT hzint
396: where sg.batch_mode_flag = p_batch_mode_flag
397: and sg.batch_id = p_batch_id
398: and sg.party_orig_system = p_original_system
399: and e.int_row_id (+) = sg.int_row_id

Line 658: FROM HZ_IMP_ADDRESSUSES_SG INT

654: BEGIN
655: -- number of new and unique recs
656: -- for l_NEW_UNIQUE_ADDRESSUSES
657: SELECT count(INT.BATCH_ID) into l_NEW_UNIQUE_ADDRESSUSES
658: FROM HZ_IMP_ADDRESSUSES_SG INT
659: WHERE INT.BATCH_ID = P_BATCH_ID AND
660: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
661: AND INT.ACTION_FLAG = 'I' ;
662: -- for l_NEW_UNIQUE_ADDRESSES

Line 737: FROM HZ_IMP_ADDRESSUSES_SG INT

733: AND INT.DQM_ACTION_FLAG IS NULL AND SG.ACTION_FLAG = 'I' ;
734: -- counts of existing entity recs
735: -- for l_EXISTING_ADDRESSUSES
736: SELECT count(INT.BATCH_ID) into l_EXISTING_ADDRESSUSES
737: FROM HZ_IMP_ADDRESSUSES_SG INT
738: WHERE INT.BATCH_ID = P_BATCH_ID AND
739: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
740: AND INT.ACTION_FLAG = 'U' ;
741: -- for l_EXISTING_ADDRESSES