APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_IMP_ADDRESSUSES_INT

Line 32: FROM HZ_IMP_ADDRESSUSES_INT INT

28: l_total_batch_records number;
29:
30: BEGIN
31: SELECT count(INT.BATCH_ID) into l_ADDRESSUSES_IN_BATCH
32: FROM HZ_IMP_ADDRESSUSES_INT INT
33: WHERE INT.BATCH_ID = P_BATCH_ID AND
34: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM ;
35: SELECT count(INT.BATCH_ID) into l_ADDRESSES_IN_BATCH
36: FROM HZ_IMP_ADDRESSES_INT INT

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

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
400: and e.request_id (+) = p_request_id
401: and e.interface_table_name (+) = 'HZ_IMP_ADDRESSUSES_INT'
402: and hpsu.party_site_use_id (+) = sg.party_site_use_id
403: -- and hpsu.request_id (+) = p_request_id
404: and sg.int_row_id = hzint.rowid (+)
405: and hzint.interface_status(+) = 'D'

Line 804: FROM HZ_IMP_ADDRESSUSES_INT INT

800: AND INT.ACTION_FLAG = 'U' ;
801:
802: -- counts of removed entity recs
803: SELECT count(INT.BATCH_ID) into l_REMOVED_ADDRESSUSES
804: FROM HZ_IMP_ADDRESSUSES_INT INT
805: WHERE INT.BATCH_ID = P_BATCH_ID AND
806: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
807: AND INT.INTERFACE_STATUS = 'R' ;
808: SELECT count(INT.BATCH_ID) into l_REMOVED_ADDRESSES