1196: AND ROWNUM < 2;
1197:
1198: -- Get sequence
1199: CURSOR c_get_conseq_cur IS
1200: SELECT fnd_concurrent_requests_s.nextval
1201: FROM dual;
1202:
1203: l_api_name CONSTANT VARCHAR2(30)
1204: := 'Build_Lead_Sales_Team';
2300: AND ACC.ACCESS_ID = TERRACC.ACCESS_ID;
2301:
2302: -- Get sequence
2303: CURSOR c_get_conseq_cur IS
2304: SELECT fnd_concurrent_requests_s.nextval
2305: FROM dual;
2306:
2307: -- Check whether owner exists or not
2308: CURSOR c_check_owner_exists(c_sales_lead_id NUMBER) IS