APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_IMP_CONTACTPTS_SG

Line 332: from hz_imp_tmp_errors e, hz_imp_contactpts_sg sg,hz_contact_points hcp, HZ_IMP_CONTACTPTS_INT hzint

328: and hzint.interface_status(+) = 'D'
329: union all
330: select /*+ full(sg) parallel(sg) */ nvl2(e.int_row_id,
331: 1, nvl2(NVL(hcp.contact_point_id,hzint.BATCH_ID),decode(sg.action_flag, 'I', 8, 9),24)) a
332: from hz_imp_tmp_errors e, hz_imp_contactpts_sg sg,hz_contact_points hcp, HZ_IMP_CONTACTPTS_INT hzint
333: where sg.batch_mode_flag = p_batch_mode_flag
334: and sg.batch_id = p_batch_id
335: and sg.party_orig_system = p_original_system
336: and e.int_row_id (+) = sg.int_row_id

Line 706: FROM HZ_IMP_CONTACTPTS_INT INT, HZ_IMP_CONTACTPTS_SG SG

702: INT.rowid = sg.int_row_id
703: AND INT.DQM_ACTION_FLAG IS NULL AND SG.ACTION_FLAG = 'I' ;
704: -- for l_NEW_UNIQUE_CONTACTPOINTS
705: SELECT count(INT.BATCH_ID) into l_NEW_UNIQUE_CONTACTPOINTS
706: FROM HZ_IMP_CONTACTPTS_INT INT, HZ_IMP_CONTACTPTS_SG SG
707: WHERE INT.BATCH_ID = P_BATCH_ID AND
708: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM AND
709: INT.BATCH_ID = SG.BATCH_ID AND
710: INT.PARTY_ORIG_SYSTEM = SG.PARTY_ORIG_SYSTEM AND

Line 779: FROM HZ_IMP_CONTACTPTS_SG INT

775: INT.CONTACT_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
776: AND INT.ACTION_FLAG = 'U' ;
777: -- for l_EXISTING_CONTACTPOINTS
778: SELECT count(INT.BATCH_ID) into l_EXISTING_CONTACTPOINTS
779: FROM HZ_IMP_CONTACTPTS_SG INT
780: WHERE INT.BATCH_ID = P_BATCH_ID AND
781: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
782: AND INT.ACTION_FLAG = 'U' ;
783: -- for l_EXISTING_CREDITRATINGS