APPS.AP_WORKFLOW_PKG dependencies on DUAL

Line 22: FROM dual;

18: l_iteration NUMBER;
19: BEGIN
20: SELECT AP_INV_APRVL_HIST_S.nextval
21: INTO l_hist_id
22: FROM dual;
23: --insert into the history table
24: INSERT INTO AP_INV_APRVL_HIST_ALL
25: (APPROVAL_HISTORY_ID
26: ,HISTORY_TYPE

Line 4329: FROM dual;

4325: l_notf_iteration := 1; /* For Now Hold Approval has only one round of
4326: Approvers */
4327: SELECT AP_NEGOTIATION_HIST_S.nextval
4328: INTO l_new_child_ItemKey
4329: FROM dual;
4330:
4331: OPEN csr_ap_hold_neg_details;
4332: FETCH csr_ap_hold_neg_details INTO
4333: l_vendor_name,

Line 4726: from dual

4722:
4723: IF l_count_rejects = 0 THEN
4724: select '&'
4725: into l_ampersand
4726: from dual
4727: where 1 like 1 escape '&';
4728: l_iteration := WF_ENGINE.GETITEMATTRNumber(itemtype,
4729: itemkey,
4730: 'ITERATION');

Line 5421: FROM dual;

5417: l_api_name,l_debug_info);
5418: END IF;
5419: SELECT AP_NEGOTIATION_HIST_S.nextval
5420: INTO l_new_child_ItemKey
5421: FROM dual;
5422:
5423: OPEN csr_ap_aprvl_neg_details;
5424: FETCH csr_ap_aprvl_neg_details INTO
5425: l_vendor_name,