APPS.JTF_RS_SALESREPS_PVT dependencies on DUAL

Line 287: -- from dual;

283:
284: -- select to_number(decode(substrb(userenv('CLIENT_INFO'),1,1),' '
285: -- ,null,substrb(userenv('CLIENT_INFO'),1,10)))
286: -- into l_org_id
287: -- from dual;
288:
289: -- dbms_output.put_line('Org id before validation : '|| l_org_id);
290: l_org_id := MO_GLOBAL.get_valid_org(p_org_id);
291: IF l_org_id is NULL THEN

Line 341: FROM dual;

337:
338: LOOP
339: SELECT jtf_rs_salesreps_s.nextval
340: INTO l_salesrep_id
341: FROM dual;
342: --dbms_output.put_line ('After Select - Salesrep ID ' || l_salesrep_id);
343:
344: OPEN c_dup_salesrep_id (l_salesrep_id, l_org_id);
345: FETCH c_dup_salesrep_id INTO l_check_dup_id;