APPS.AS_OPP_INITIAL_LOG_PKG dependencies on AS_LEADS_ALL

Line 69: FROM AS_LEADS_ALL a

65: 'I', a.CUSTOMER_ID , a.DESCRIPTION ,a.SOURCE_PROMOTION_ID ,
66: a.OFFER_ID , a.CLOSE_COMPETITOR_ID , a.VEHICLE_RESPONSE_CODE , a.SALES_METHODOLOGY_ID ,
67: a.OWNER_SALESFORCE_ID ,a.OWNER_SALES_GROUP_ID , a.ORG_ID,
68: LAST_UPDATE_DATE, LAST_UPDATE_DATE, 0, 'Y', 1
69: FROM AS_LEADS_ALL a
70: where a.lead_id not in ( select log.lead_id from AS_LEADS_LOG log);
71:
72: write_log(l_module, G_DEBUG_CONCURRENT, 1, 'Refresh of as_leads_log Process Completed @: '||to_char(sysdate,'DD-MON-RRRR:HH:MI:SS'));
73: COMMIT;