APPS.BIM_CAMPAIGN_FACTS dependencies on AS_SALES_LEADS_LOG
Line 84: FROM as_sales_leads a, as_sales_leads_log b
80:
81: FUNCTION ret_max_date(p_sales_lead_id in number) return date is
82: CURSOR get_max_date IS
83: SELECT max(b.creation_date) 84: FROM as_sales_leads a, as_sales_leads_log b 85: WHERE a.sales_lead_id = b.sales_lead_id
86: AND b.sales_lead_id = p_sales_lead_id ;
87:
88: l_date date;