APPS.PV_PARTNER_TREND_PVT dependencies on AS_LEADS_ALL

Line 28: pv_lead_workflows a, pv_lead_assignments b, as_leads_all c, as_statuses_b d

24:
25: cursor c1 (pc_id number) is
26: select sum(offset_cnt) from
27: (select a.lead_id,count(*)-1 offset_cnt from
28: pv_lead_workflows a, pv_lead_assignments b, as_leads_all c, as_statuses_b d
29: where a.wf_item_type = b.wf_item_type
30: and a.wf_item_key = b.wf_item_key
31: and a.latest_routing_flag = 'Y'
32: and a.routing_status = 'ACTIVE'

Line 69: FROM PV_LEAD_WORKFLOWS A, PV_LEAD_ASSIGNMENTS B, AS_LEADS_ALL C, AS_STATUSES_B D

65: cursor c1 (pc_id number, pc_currency varchar2) is
66: select sum(offset_AMT) from
67: (SELECT A.LEAD_ID,SUM(pv_check_match_pub.currency_conversion(c.total_amount,
68: c.currency_code,sysdate, pc_currency)) /count(*) * (count(*)-1) offset_amt
69: FROM PV_LEAD_WORKFLOWS A, PV_LEAD_ASSIGNMENTS B, AS_LEADS_ALL C, AS_STATUSES_B D
70: WHERE A.WF_ITEM_TYPE = B.WF_ITEM_TYPE
71: AND A.WF_ITEM_KEY = B.WF_ITEM_KEY
72: AND A.LATEST_ROUTING_FLAG = 'Y'
73: AND A.ROUTING_STATUS = 'ACTIVE'