APPS.ASN_MIG_SALES_TEAM_PVT dependencies on AS_LEADS_ALL

Line 186: FROM as_leads_all

182: l_user_id NUMBER;
183:
184: /* CURSOR c_opps_in_range(p_start_id NUMBER, p_end_id NUMBER) IS
185: SELECT lead_id, customer_id
186: FROM as_leads_all
187: WHERE lead_id BETWEEN p_start_id AND p_end_id; */
188:
189: CURSOR c_opps_in_range(p_start_id NUMBER, p_end_id NUMBER) IS
190: SELECT DISTINCT lead_id

Line 634: FROM as_leads_all

630: l_dummy NUMBER:=0;
631:
632: CURSOR c_opps_in_range(p_start_id NUMBER, p_end_id NUMBER) IS
633: SELECT lead_id, customer_id
634: FROM as_leads_all
635: WHERE lead_id BETWEEN p_start_id AND p_end_id;
636:
637: CURSOR c2 IS SELECT as_leads_s.nextval FROM dual;
638:

Line 799: -- Get maximum number of possible rows in as_leads_all

795: --
796:
797:
798: --
799: -- Get maximum number of possible rows in as_leads_all
800: --
801: /* OPEN c1;
802: FETCH c1 INTO l_max_num_rows;
803: CLOSE c1; */ -- @@

Line 1253: CURSOR c1 IS SELECT count(lead_id) FROM as_leads_all;

1249: l_end_id NUMBER;
1250: l_batch_size CONSTANT NUMBER := 10000;
1251:
1252: -- CURSOR c1 IS SELECT as_leads_s.nextval FROM dual;
1253: CURSOR c1 IS SELECT count(lead_id) FROM as_leads_all;
1254:
1255: BEGIN
1256:
1257: --

Line 1273: -- Get maximum number of possible rows in as_leads_all

1269: ',p_debug_flag=' || p_debug_flag);
1270: END IF;
1271:
1272: --
1273: -- Get maximum number of possible rows in as_leads_all
1274: --
1275: OPEN c1;
1276: FETCH c1 INTO l_max_num_rows;
1277: CLOSE c1;

Line 1516: FROM as_leads_all;

1512:
1513: -- CURSOR c_opps_in_range(p_start_id NUMBER, p_end_id NUMBER) IS
1514: CURSOR c_opps_in_range IS
1515: SELECT lead_id, customer_id
1516: FROM as_leads_all;
1517:
1518: CURSOR c_lead_line_logs(p_lead_id NUMBER) IS
1519: SELECT log_id, lead_line_id, last_update_date
1520: FROM as_lead_lines_log