APPS.AS_LEAD_ROUTING_WF dependencies on AS_SALES_LEAD_RANKS_B

Line 917: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk

913: -- Get lead_rank_score and lead creation_date
914: CURSOR c_get_open_status_flag(c_sales_lead_id NUMBER) IS
915: SELECT DECODE(sta.opp_open_status_flag, 'Y', 'Y', 'N', NULL),
916: rk.min_score, sl.creation_date
917: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk
918: WHERE sl.sales_lead_id = c_sales_lead_id
919: AND sl.status_code = sta.status_code
920: AND sl.lead_rank_id = rk.rank_id(+);
921: BEGIN