APPS.ASN_MIG_SALES_TEAM_PVT dependencies on DUAL

Line 222: CURSOR c1 IS SELECT as_leads_s.nextval FROM dual;

218: WHERE lead_id = p_lead_id
219: GROUP BY lead_id,salesforce_id, sales_group_id, partner_customer_id,
220: partner_cont_party_id;
221:
222: CURSOR c1 IS SELECT as_leads_s.nextval FROM dual;
223: l_max_num_rows NUMBER;
224: --Code added for ASN migration approach suggested by lester -- End
225:
226: BEGIN

Line 613: CURSOR c1 IS SELECT hz_parties_s.nextval FROM dual;

609: l_start_id NUMBER;
610: l_end_id NUMBER;
611: l_batch_size CONSTANT NUMBER := 10000;
612:
613: CURSOR c1 IS SELECT hz_parties_s.nextval FROM dual;
614:
615: --Code added for ASN migration approach suggested by lester -- Start
616: ls_create_temp varchar2(1000);
617: l_dup_count_cust NUMBER;

Line 637: CURSOR c2 IS SELECT as_leads_s.nextval FROM dual;

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:
639: l_lead_id NUMBER;
640: l_customer_id NUMBER;
641: l_custfix_count NUMBER;

Line 1252: -- CURSOR c1 IS SELECT as_leads_s.nextval FROM dual;

1248: l_start_id NUMBER;
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: