DBA Data[Home] [Help]

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;