APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_IMP_RELSHIPS_SG

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 466: from hz_imp_relships_sg

462: IF l_sst_flag='Y'
463: THEN
464: select count(*)
465: into l_rels_updated
466: from hz_imp_relships_sg
467: where batch_id=p_batch_id
468: and action_flag='U'
469: and relationship_type in
470: ('HEADQUARTERS/DIVISION','PARENT/SUBSIDIARY','DOMESTIC_ULTIMATE','GLOBAL_ULTIMATE')

Line 685: FROM HZ_IMP_RELSHIPS_SG INT

681: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
682: AND INT.ACTION_FLAG = 'I' ;
683: -- for l_NEW_UNIQUE_RELATIONSHIPS
684: SELECT count(INT.BATCH_ID) into l_NEW_UNIQUE_RELATIONSHIPS
685: FROM HZ_IMP_RELSHIPS_SG INT
686: WHERE INT.BATCH_ID = P_BATCH_ID AND
687: INT.SUB_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
688: AND INT.ACTION_FLAG = 'I' ;
689: -- for l_NEW_UNIQUE_CONTACTROLES

Line 761: FROM HZ_IMP_RELSHIPS_SG INT

757: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
758: AND INT.ACTION_FLAG = 'U' ;
759: -- for l_EXISTING_RELATIONSHIPS
760: SELECT count(INT.BATCH_ID) into l_EXISTING_RELATIONSHIPS
761: FROM HZ_IMP_RELSHIPS_SG INT
762: WHERE INT.BATCH_ID = P_BATCH_ID AND
763: INT.SUB_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
764: AND INT.ACTION_FLAG = 'U' ;
765: -- for l_EXISTING_CONTACTROLES