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,
63: pv_lookups plkp1
169: select
170: ldwf.failure_code,
171: ldwf.failure_message
172: from
173: pv_lead_workflows ldwf
174: where
175: ldwf.lead_workflow_id= pc_lead_workflow_id
176: ;
177: