APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_IMP_CLASSIFICS_SG

Line 437: from hz_imp_tmp_errors e, hz_imp_classifics_sg sg,hz_code_assignments hca, HZ_IMP_CLASSIFICS_INT hzint

433: and hzint.interface_status(+) = 'D'
434: union all
435: select /*+ full(sg) parallel(sg) */ nvl2(e.int_row_id,
436: 1, nvl2(NVL(hca.code_assignment_id,hzint.BATCH_ID),decode(sg.action_flag, 'I', 22, 23),24)) a
437: from hz_imp_tmp_errors e, hz_imp_classifics_sg sg,hz_code_assignments hca, HZ_IMP_CLASSIFICS_INT hzint
438: where sg.batch_mode_flag = p_batch_mode_flag
439: and sg.batch_id = p_batch_id
440: and sg.party_orig_system = p_original_system
441: and e.int_row_id (+) = sg.int_row_id

Line 679: FROM HZ_IMP_CLASSIFICS_SG INT

675: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
676: AND INT.ACTION_FLAG = 'I' ;
677: -- for l_NEW_UNIQUE_CODEASSIGNS
678: SELECT count(INT.BATCH_ID) into l_NEW_UNIQUE_CODEASSIGNS
679: FROM HZ_IMP_CLASSIFICS_SG INT
680: WHERE INT.BATCH_ID = P_BATCH_ID AND
681: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
682: AND INT.ACTION_FLAG = 'I' ;
683: -- for l_NEW_UNIQUE_RELATIONSHIPS

Line 755: FROM HZ_IMP_CLASSIFICS_SG INT

751: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
752: AND INT.ACTION_FLAG = 'U' ;
753: -- for l_EXISTING_CODEASSIGNS
754: SELECT count(INT.BATCH_ID) into l_EXISTING_CODEASSIGNS
755: FROM HZ_IMP_CLASSIFICS_SG INT
756: WHERE INT.BATCH_ID = P_BATCH_ID AND
757: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
758: AND INT.ACTION_FLAG = 'U' ;
759: -- for l_EXISTING_RELATIONSHIPS