APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_IMP_CREDITRTNGS_SG

Line 423: from hz_imp_tmp_errors e, hz_imp_creditrtngs_sg sg,hz_credit_ratings hcr, HZ_IMP_CREDITRTNGS_INT hzint

419: and hzint.interface_status(+) = 'D'
420: union all
421: select /*+ full(sg) parallel(sg) */ nvl2(e.int_row_id,
422: 1, nvl2(NVL(hcr.credit_rating_id,hzint.BATCH_ID),decode(sg.action_flag, 'I', 20, 21),24)) a
423: from hz_imp_tmp_errors e, hz_imp_creditrtngs_sg sg,hz_credit_ratings hcr, HZ_IMP_CREDITRTNGS_INT hzint
424: where sg.batch_mode_flag = p_batch_mode_flag
425: and sg.batch_id = p_batch_id
426: and sg.party_orig_system = p_original_system
427: and e.int_row_id (+) = sg.int_row_id

Line 715: FROM HZ_IMP_CREDITRTNGS_SG INT

711: INT.rowid = sg.int_row_id
712: AND INT.DQM_ACTION_FLAG IS NULL AND SG.ACTION_FLAG = 'I' ;
713: -- for l_NEW_UNIQUE_CREDITRATINGS
714: SELECT count(INT.BATCH_ID) into l_NEW_UNIQUE_CREDITRATINGS
715: FROM HZ_IMP_CREDITRTNGS_SG INT
716: WHERE INT.BATCH_ID = P_BATCH_ID AND
717: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
718: AND INT.ACTION_FLAG = 'I' ;
719: -- for l_NEW_UNIQUE_FINREPORTS

Line 785: FROM HZ_IMP_CREDITRTNGS_SG INT

781: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
782: AND INT.ACTION_FLAG = 'U' ;
783: -- for l_EXISTING_CREDITRATINGS
784: SELECT count(INT.BATCH_ID) into l_EXISTING_CREDITRATINGS
785: FROM HZ_IMP_CREDITRTNGS_SG INT
786: WHERE INT.BATCH_ID = P_BATCH_ID AND
787: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
788: AND INT.ACTION_FLAG = 'U' ;
789: -- for l_EXISTING_FINREPORTS