APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_IMP_FINNUMBERS_SG

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 673: FROM HZ_IMP_FINNUMBERS_SG INT

669: INT.rowid = sg.int_row_id
670: AND INT.DQM_ACTION_FLAG IS NULL AND SG.ACTION_FLAG = 'I' ;
671: -- for l_NEW_UNIQUE_FINNUMBERS
672: SELECT count(INT.BATCH_ID) into l_NEW_UNIQUE_FINNUMBERS
673: FROM HZ_IMP_FINNUMBERS_SG INT
674: WHERE INT.BATCH_ID = P_BATCH_ID AND
675: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
676: AND INT.ACTION_FLAG = 'I' ;
677: -- for l_NEW_UNIQUE_CODEASSIGNS

Line 749: FROM HZ_IMP_FINNUMBERS_SG INT

745: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
746: AND INT.ACTION_FLAG = 'U' ;
747: -- for l_EXISTING_FINNUMBERS
748: SELECT count(INT.BATCH_ID) into l_EXISTING_FINNUMBERS
749: FROM HZ_IMP_FINNUMBERS_SG INT
750: WHERE INT.BATCH_ID = P_BATCH_ID AND
751: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
752: AND INT.ACTION_FLAG = 'U' ;
753: -- for l_EXISTING_CODEASSIGNS