APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_IMP_CLASSIFICS_INT

Line 44: FROM HZ_IMP_CLASSIFICS_INT INT

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
45: WHERE INT.BATCH_ID = P_BATCH_ID AND
46: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM ;
47: SELECT count(INT.BATCH_ID) into l_RELATIONSHIPS_IN_BATCH
48: FROM HZ_IMP_RELSHIPS_INT INT

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

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
442: and e.request_id (+) = p_request_id
443: and e.interface_table_name (+) = 'HZ_IMP_CLASSIFICS_INT'
444: and hca.code_assignment_id (+) = sg.code_assignment_id
445: and hca.request_id (+) = p_request_id
446: and sg.int_row_id = hzint.rowid (+)
447: and hzint.interface_status(+) = 'D'

Line 819: FROM HZ_IMP_CLASSIFICS_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
819: FROM HZ_IMP_CLASSIFICS_INT INT
820: WHERE INT.BATCH_ID = P_BATCH_ID AND
821: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
822: AND INT.INTERFACE_STATUS = 'R' ;
823: SELECT count(INT.BATCH_ID) into l_REMOVED_RELATIONSHIPS