APPS.PV_PARTNER_TREND_PVT dependencies on PV_CHECK_MATCH_PUB

Line 67: (SELECT A.LEAD_ID,SUM(pv_check_match_pub.currency_conversion(c.total_amount,

63: FUNCTION kpi_oppty_amt_offset(p_salesforce_id number, p_currency_code varchar2) return number as
64:
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