APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_IMP_FINNUMBERS_INT

Line 40: FROM HZ_IMP_FINNUMBERS_INT INT

36: FROM HZ_IMP_ADDRESSES_INT INT
37: WHERE INT.BATCH_ID = P_BATCH_ID AND
38: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM ;
39: SELECT count(INT.BATCH_ID) into l_FINNUMBERS_IN_BATCH
40: FROM HZ_IMP_FINNUMBERS_INT INT
41: WHERE INT.BATCH_ID = P_BATCH_ID AND
42: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM ;
43: SELECT count(INT.BATCH_ID) into l_CODEASSIGNS_IN_BATCH
44: FROM HZ_IMP_CLASSIFICS_INT INT

Line 304: from hz_imp_tmp_errors e, hz_imp_finnumbers_sg sg,hz_financial_numbers fnn, HZ_IMP_FINNUMBERS_INT hzint

300: and hzint.interface_status(+) = 'D'
301: union all
302: select /*+ full(sg) parallel(sg) */ nvl2(e.int_row_id,
303: 1, nvl2(NVL(fnn.financial_number_id,hzint.BATCH_ID),decode(sg.action_flag, 'I', 4, 5),24)) a
304: from hz_imp_tmp_errors e, hz_imp_finnumbers_sg sg,hz_financial_numbers fnn, HZ_IMP_FINNUMBERS_INT hzint
305: where sg.batch_mode_flag = p_batch_mode_flag
306: and sg.batch_id = p_batch_id
307: and sg.party_orig_system = p_original_system
308: and e.int_row_id (+) = sg.int_row_id

Line 310: and e.interface_table_name (+) = 'HZ_IMP_FINNUMBERS_INT'

306: and sg.batch_id = p_batch_id
307: and sg.party_orig_system = p_original_system
308: and e.int_row_id (+) = sg.int_row_id
309: and e.request_id (+) = p_request_id
310: and e.interface_table_name (+) = 'HZ_IMP_FINNUMBERS_INT'
311: and fnn.financial_number_id (+) = sg.financial_number_id
312: and fnn.request_id(+) = p_request_id
313: and sg.int_row_id = hzint.rowid (+)
314: and hzint.interface_status(+) = 'D'

Line 814: FROM HZ_IMP_FINNUMBERS_INT INT

810: WHERE INT.BATCH_ID = P_BATCH_ID AND
811: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
812: AND INT.INTERFACE_STATUS = 'R' ;
813: SELECT count(INT.BATCH_ID) into l_REMOVED_FINNUMBERS
814: FROM HZ_IMP_FINNUMBERS_INT INT
815: WHERE INT.BATCH_ID = P_BATCH_ID AND
816: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
817: AND INT.INTERFACE_STATUS = 'R' ;
818: SELECT count(INT.BATCH_ID) into l_REMOVED_CODEASSIGNS