APPS.PA_DCTN_APRV_NOTIFICATION dependencies on DUAL

Line 29: SELECT SYSDATE FROM SYS.DUAL;

25: AND e.effective_end_date = ( SELECT MAX(papf.effective_end_date)
26: FROM per_all_people_f papf
27: WHERE papf.person_id = e.person_id);
28: CURSOR c_wf_started_date IS
29: SELECT SYSDATE FROM SYS.DUAL;
30:
31: CURSOR c_vendor_info (c_vendor_id NUMBER) IS
32: SELECT pov.vendor_name Vendor_Name
33: FROM PO_VENDORS pov

Line 80: FROM DUAL;

76:
77: --get the unique identifier for this specific workflow
78: SELECT pa_workflow_itemkey_s.nextval
79: INTO itemkey
80: FROM DUAL;
81:
82: -- Need this to populate the attribute information in Workflow
83: l_workflow_started_by_id := FND_GLOBAL.user_id;
84: l_resp_id := FND_GLOBAL.resp_id;