APPS.PA_PWP_NOTIFICATION dependencies on DUAL

Line 155: FROM sys.dual;

151: -- Get System Date for Worflow-Started-Date
152: CURSOR c_wf_started_date
153: IS
154: SELECT sysdate
155: FROM sys.dual;
156:
157:
158: l_inv_info_rec c_inv_info%ROWTYPE;
159: l_inv_rec c_invoice%ROWTYPE;

Line 214: from dual;

210:
211: --get the unique identifier for this specific workflow
212: SELECT pa_workflow_itemkey_s.nextval
213: INTO ItemKey
214: from dual;
215:
216: -- Need this to populate the attribute information in Workflow
217: l_workflow_started_by_id := FND_GLOBAL.user_id;
218: l_resp_id := FND_GLOBAL.resp_id;