APPS.AP_WORKFLOW_PKG dependencies on DUAL

Line 24: FROM dual;

20: -- Bug 9861713 PRAGMA AUTONOMOUS_TRANSACTION; bug 8450681
21: BEGIN
22: SELECT AP_INV_APRVL_HIST_S.nextval
23: INTO l_hist_id
24: FROM dual;
25:
26: --insert into the history table
27: INSERT INTO AP_INV_APRVL_HIST_ALL
28: (APPROVAL_HISTORY_ID

Line 4456: FROM dual;

4452: l_notf_iteration := 1; /* For Now Hold Approval has only one round of
4453: Approvers */
4454: SELECT AP_NEGOTIATION_HIST_S.nextval
4455: INTO l_new_child_ItemKey
4456: FROM dual;
4457:
4458: OPEN csr_ap_hold_neg_details;
4459: FETCH csr_ap_hold_neg_details INTO
4460: l_vendor_name,

Line 4861: from dual

4857:
4858: IF l_count_rejects = 0 THEN
4859: select '&'
4860: into l_ampersand
4861: from dual
4862: where 1 like 1 escape '&';
4863: l_iteration := WF_ENGINE.GETITEMATTRNumber(itemtype,
4864: itemkey,
4865: 'ITERATION');

Line 5662: FROM dual;

5658: l_api_name,l_debug_info);
5659: END IF;
5660: SELECT AP_NEGOTIATION_HIST_S.nextval
5661: INTO l_new_child_ItemKey
5662: FROM dual;
5663:
5664: OPEN csr_ap_aprvl_neg_details;
5665: FETCH csr_ap_aprvl_neg_details INTO
5666: l_vendor_name,