DBA Data[Home] [Help]

APPS.PV_PARTNER_TREND_PVT dependencies on JTF_RS_GROUP_USAGES

Line 41: jtf_rs_group_usages cc where bb.parent_resource_id = pc_id

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
45: and aa.partner_id = b.partner_id

Line 83: jtf_rs_group_usages cc where bb.parent_resource_id = pc_id

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
87: and aa.partner_id = b.partner_id