APPS.BIM_MARKET_FACTS_PKG dependencies on AS_SALES_LEADS

Line 13: FROM as_sales_leads a, as_sales_leads_log b

9: l_sgc_rate_type CONSTANT VARCHAR2(20) :=bis_common_parameters.Get_secondary_Rate_Type;
10: FUNCTION ret_max_date(p_sales_lead_id in number) return date is
11: CURSOR get_max_date IS
12: SELECT max(b.creation_date)
13: FROM as_sales_leads a, as_sales_leads_log b
14: WHERE a.sales_lead_id = b.sales_lead_id
15: AND b.sales_lead_id = p_sales_lead_id ;
16:
17: l_date date;