153:
154:
155: -- Cursors to fetch data from OSO Tables
156: 157: -- AS_LEADS_ALL 158: CURSOR C_lead (p_lead_id NUMBER) IS
159: SELECT offer_id
160: FROM as_leads_all
161: WHERE lead_id = p_lead_id;
Line 160: FROM as_leads_all
156:
157: -- AS_LEADS_ALL
158: CURSOR C_lead (p_lead_id NUMBER) IS
159: SELECT offer_id 160: FROM as_leads_all 161: WHERE lead_id = p_lead_id;
162:
163: l_lead_rec c_lead%ROWTYPE;
164: