910:
911: cursor lc_get_lead_detail (pc_lead_id number) is
912: select customer_id, address_id, source_promotion_id from as_leads_all where lead_id = pc_lead_id;
913:
914: l_partner_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
915: l_partner_rank_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
916: l_partner_source_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
917:
918: l_partner_id_tmp NUMBER;
911: cursor lc_get_lead_detail (pc_lead_id number) is
912: select customer_id, address_id, source_promotion_id from as_leads_all where lead_id = pc_lead_id;
913:
914: l_partner_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
915: l_partner_rank_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
916: l_partner_source_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
917:
918: l_partner_id_tmp NUMBER;
919: l_partner_rank_tmp NUMBER;