APPS.PV_OPPTY_ROUTING_LOG dependencies on PV_LEAD_ASSIGNMENTS

Line 58: pv_lead_assignments assgn,

54: 'Y',fnd_message.get_string('PV','PV_ASSIGN_CM_APPRVL_NOT_REQ'),
55: fnd_message.get_string('PV','PV_ASSIGN_CM_APPRVL_NOTREQ')) bypass_message,
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,

Line 80: pv_lead_assignments assgn,

76: IS
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

Line 93: pv_lead_assignments assgn,

89: IS
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

Line 106: pv_lead_assignments assgn,

102: IS
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

Line 119: pv_lead_assignments assgn,

115: IS
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

Line 228: pv_lead_assignments ldass

224: if(l_cm_timeout = 'Y' ) then
225: select ldall.description
226: into l_lead_description
227: from as_leads_all ldall,
228: pv_lead_assignments ldass
229: where ldass.lead_id=ldall.lead_id and
230: ldass.lead_assignment_id=p_lead_assignment_id;
231:
232: l_addtnl_details := l_addtnl_details || gc_oppty_cm_timeout_message || ': ' || l_lead_description || '.
';