APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_IMP_CREDITRTNGS_INT

Line 64: FROM HZ_IMP_CREDITRTNGS_INT INT

60: FROM HZ_IMP_CONTACTPTS_INT INT
61: WHERE INT.BATCH_ID = P_BATCH_ID AND
62: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM ;
63: SELECT count(INT.BATCH_ID) into l_CREDITRATINGS_IN_BATCH
64: FROM HZ_IMP_CREDITRTNGS_INT INT
65: WHERE INT.BATCH_ID = P_BATCH_ID AND
66: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM ;
67: SELECT count(INT.BATCH_ID) into l_FINREPORTS_IN_BATCH
68: FROM HZ_IMP_FINREPORTS_INT INT

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

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
428: and e.request_id (+) = p_request_id
429: and e.interface_table_name (+) = 'HZ_IMP_CREDITRTNGS_INT'
430: and hcr.credit_rating_id(+) = sg.credit_rating_id
431: and hcr.request_id (+) = p_request_id
432: and sg.int_row_id = hzint.rowid (+)
433: and hzint.interface_status(+) = 'D'

Line 844: FROM HZ_IMP_CREDITRTNGS_INT INT

840: WHERE INT.BATCH_ID = P_BATCH_ID AND
841: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
842: AND INT.INTERFACE_STATUS = 'R' ;
843: SELECT count(INT.BATCH_ID) into l_REMOVED_CREDITRATINGS
844: FROM HZ_IMP_CREDITRTNGS_INT INT
845: WHERE INT.BATCH_ID = P_BATCH_ID AND
846: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
847: AND INT.INTERFACE_STATUS = 'R' ;
848: SELECT count(INT.BATCH_ID) into l_REMOVED_FINREPORTS