APPS.BIM_LEAD_IMPORT_FACTS_PKG dependencies on AS_LEAD_IMPORT_ERRORS

Line 439: AS_LEAD_IMPORT_ERRORS B

435: 0 leads_valid,
436: 0 leads_new,
437: decode(A.Load_Status, 'ERROR', 1,'UNEXP_ERROR', 1, 0) leads_Invalid
438: from AS_IMPORT_INTERFACE a,
439: AS_LEAD_IMPORT_ERRORS B
440: where a.last_update_date between p_start_datel and p_end_datel +0.9999
441: and a.Import_interface_id = B.import_interface_id(+)
442: AND a.load_status IN ('ERROR', 'UNEXP_ERROR')
443: group by a.promotion_code,