APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_IMP_RELSHIPS_INT

Line 48: FROM HZ_IMP_RELSHIPS_INT INT

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
49: WHERE INT.BATCH_ID = P_BATCH_ID AND
50: INT.SUB_ORIG_SYSTEM = P_ORIGINAL_SYSTEM ;
51: SELECT count(INT.BATCH_ID) into l_CONTACTROLES_IN_BATCH
52: FROM HZ_IMP_CONTACTROLES_INT INT

Line 289: from hz_imp_tmp_errors e, hz_imp_relships_sg sg,hz_relationships rel, HZ_IMP_RELSHIPS_INT hzint

285: where rownum < 24) x, (
286: select a, count(*) ct from (
287: select /*+ full(sg) parallel(sg) */ nvl2(e.int_row_id,
288: 1, nvl2(NVL(rel.relationship_id,hzint.BATCH_ID),decode(sg.action_flag, 'I', 2, 3),24)) a
289: from hz_imp_tmp_errors e, hz_imp_relships_sg sg,hz_relationships rel, HZ_IMP_RELSHIPS_INT hzint
290: where sg.batch_mode_flag = p_batch_mode_flag
291: and sg.batch_id = p_batch_id
292: and sg.sub_orig_system = p_original_system
293: and e.int_row_id (+) = sg.int_row_id

Line 295: and e.interface_table_name (+) = 'HZ_IMP_RELSHIPS_INT'

291: and sg.batch_id = p_batch_id
292: and sg.sub_orig_system = p_original_system
293: and e.int_row_id (+) = sg.int_row_id
294: and e.request_id (+) = p_request_id
295: and e.interface_table_name (+) = 'HZ_IMP_RELSHIPS_INT'
296: and rel.relationship_id (+) = sg.relationship_id
297: and rel.request_id (+) = p_request_id
298: and rel.directional_flag(+) = 'F'
299: and sg.int_row_id = hzint.rowid (+)

Line 824: FROM HZ_IMP_RELSHIPS_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
824: FROM HZ_IMP_RELSHIPS_INT INT
825: WHERE INT.BATCH_ID = P_BATCH_ID AND
826: INT.SUB_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
827: AND INT.INTERFACE_STATUS = 'R' ;
828: SELECT count(INT.BATCH_ID) into l_REMOVED_CONTACTROLES