APPS.OKL_SO_CREDIT_APP_WF dependencies on DUAL

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

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

Line 338: from dual;

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

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

1586: RETURN;
1587: END ;
1588:
1589: -- 3. Get Request Number
1590: select okl_wf_item_s.nextval INTO l_seq FROM DUAL ;
1591: ls_request_num := l_quote_number ||l_seq ;
1592:
1593: -- 4. CREATE credit app request
1594: l_crqv_rec_type.QUOTE_ID := l_quote_id ;