APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_IMP_FINREPORTS_SG

Line 318: from hz_imp_tmp_errors e, hz_imp_finreports_sg sg,hz_financial_reports fnr, HZ_IMP_FINREPORTS_INT hzint

314: and hzint.interface_status(+) = 'D'
315: union all
316: select /*+ full(sg) parallel(sg) */ nvl2(e.int_row_id,
317: 1, nvl2(NVL(fnr.financial_report_id,hzint.BATCH_ID),decode(sg.action_flag, 'I', 6, 7),24)) a
318: from hz_imp_tmp_errors e, hz_imp_finreports_sg sg,hz_financial_reports fnr, HZ_IMP_FINREPORTS_INT hzint
319: where sg.batch_mode_flag = p_batch_mode_flag
320: and sg.batch_id = p_batch_id
321: and sg.party_orig_system = p_original_system
322: and e.int_row_id (+) = sg.int_row_id

Line 721: FROM HZ_IMP_FINREPORTS_SG INT

717: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
718: AND INT.ACTION_FLAG = 'I' ;
719: -- for l_NEW_UNIQUE_FINREPORTS
720: SELECT count(INT.BATCH_ID) into l_NEW_UNIQUE_FINREPORTS
721: FROM HZ_IMP_FINREPORTS_SG INT
722: WHERE INT.BATCH_ID = P_BATCH_ID AND
723: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
724: AND INT.ACTION_FLAG = 'I' ;
725: -- for l_NEW_UNIQUE_PARTIES

Line 791: FROM HZ_IMP_FINREPORTS_SG INT

787: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
788: AND INT.ACTION_FLAG = 'U' ;
789: -- for l_EXISTING_FINREPORTS
790: SELECT count(INT.BATCH_ID) into l_EXISTING_FINREPORTS
791: FROM HZ_IMP_FINREPORTS_SG INT
792: WHERE INT.BATCH_ID = P_BATCH_ID AND
793: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
794: AND INT.ACTION_FLAG = 'U' ;
795: -- for l_EXISTING_PARTIES