DBA Data[Home] [Help]

APPS.PV_PARTNER_TREND_PVT dependencies on PV_PARTNER_ACCESSES

Line 40: from pv_partner_accesses aa, jtf_rs_rep_managers bb,

36: and c.status = d.status_code
37: and d.opp_open_status_flag = 'Y'
38: and exists
39: (select 1
40: from pv_partner_accesses aa, jtf_rs_rep_managers bb,
41: jtf_rs_group_usages cc where bb.parent_resource_id = pc_id
42: and nvl(bb.end_date_active, sysdate) >= sysdate
43: and bb.group_id = cc.group_id and cc.usage = 'PRM'
44: and bb.resource_id = aa.resource_id

Line 82: from pv_partner_accesses aa, jtf_rs_rep_managers bb,

78: and c.status = d.status_code
79: and d.opp_open_status_flag = 'Y'
80: and exists
81: (select 1
82: from pv_partner_accesses aa, jtf_rs_rep_managers bb,
83: jtf_rs_group_usages cc where bb.parent_resource_id = pc_id
84: and nvl(bb.end_date_active, sysdate) >= sysdate
85: and bb.group_id = cc.group_id and cc.usage = 'PRM'
86: and bb.resource_id = aa.resource_id