APPS.PV_OPPTY_ROUTING_LOG dependencies on PV_PARTNER_PROFILES

Line 60: pv_partner_profiles partprof,

56: plkp1.meaning routing_type_meaning
57: FROM
58: pv_lead_assignments assgn,
59: pv_lead_workflows ldwf,
60: pv_partner_profiles partprof,
61: hz_parties party,
62: pv_oppty_routing_logs logs,
63: pv_lookups plkp1
64: WHERE

Line 81: pv_partner_profiles partprof,

77: SELECT
78: party.party_name
79: FROM
80: pv_lead_assignments assgn,
81: pv_partner_profiles partprof,
82: hz_parties party
83: WHERE
84: assgn.lead_assignment_id = pc_lead_assignment_id --10569
85: and assgn.partner_id = partprof.partner_id

Line 94: pv_partner_profiles partprof,

90: SELECT
91: party.party_name
92: FROM
93: pv_lead_assignments assgn,
94: pv_partner_profiles partprof,
95: hz_parties party
96: WHERE
97: assgn.lead_assignment_id = pc_lead_assignment_id --10569
98: and assgn.partner_id = partprof.partner_id

Line 107: pv_partner_profiles partprof,

103: SELECT
104: party.party_name
105: FROM
106: pv_lead_assignments assgn,
107: pv_partner_profiles partprof,
108: hz_parties party
109: WHERE
110: assgn.lead_assignment_id = pc_lead_assignment_id --10569
111: and assgn.partner_id = partprof.partner_id

Line 120: pv_partner_profiles partprof,

116: SELECT
117: party.party_name
118: FROM
119: pv_lead_assignments assgn,
120: pv_partner_profiles partprof,
121: hz_parties party
122: WHERE
123: assgn.lead_assignment_id = pc_lead_assignment_id --10569
124: and assgn.partner_id = partprof.partner_id