APPS.ASN_MIG_SALES_CREDITS_PVT dependencies on DUAL

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

66: l_rows_per_worker NUMBER;
67: l_start_id NUMBER;
68: l_end_id NUMBER;
69:
70: CURSOR c1 IS SELECT as_leads_s.nextval FROM dual;
71:
72: BEGIN
73:
74: --

Line 628: dual

624: ,'Y'
625: ,NULL
626: ,1
627: FROM
628: dual
629: WHERE
630: l_ranks(i) = 1
631: AND NOT EXISTS (SELECT 1 FROM as_accesses_all ACS
632: WHERE ACS.lead_id IS NOT NULL

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

1850: l_start_id NUMBER;
1851: l_end_id NUMBER;
1852: l_batch_size CONSTANT NUMBER := 10000;
1853:
1854: CURSOR c1 IS SELECT as_leads_s.nextval FROM dual;
1855:
1856: BEGIN
1857:
1858: --

Line 2266: FROM SYS.DUAL;

2262: WHERE opportunity_id = p_lead_id;
2263:
2264: CURSOR c_get_access_id IS
2265: SELECT AS_ACCESSES_S.NEXTVAL
2266: FROM SYS.DUAL;
2267:
2268: -- Add person to sales team if he is recieving credits
2269: -- not checking for address or sales role as this is not
2270: -- enterable field in ASN UI