APPS.OKL_SO_CREDIT_APP_WF dependencies on DUAL

Line 58: select okl_wf_item_s.nextval INTO l_seq FROM DUAL ;

54: l_yn := exist_subscription(l_event_name);
55: IF l_yn = 'Y' THEN
56:
57: --Get the item key
58: select okl_wf_item_s.nextval INTO l_seq FROM DUAL ;
59: l_key := l_event_name ||l_seq ;
60:
61: --Set Parameters
62: wf_event.AddParameterToList('QUOTE_ID',TO_CHAR(p_quote_id),l_parameter_list);

Line 335: from dual;

331: ,to_number(null) id -- okl credit request id
332: ,to_number(null) quote_id
333: ,null status -- lookup code (not meaning)
334: ,null currency_code
335: from dual;
336:
337:
338: CURSOR c_recomendation (b_credit_request_id IN NUMBER) IS
339: SELECT

Line 1412: select okl_wf_item_s.nextval INTO l_seq FROM DUAL ;

1408: RETURN;
1409: END ;
1410:
1411: -- 3. Get Request Number
1412: select okl_wf_item_s.nextval INTO l_seq FROM DUAL ;
1413: ls_request_num := l_quote_number ||l_seq ;
1414:
1415: -- 4. CREATE credit app request
1416: l_crqv_rec_type.QUOTE_ID := l_quote_id ;