DBA Data[Home] [Help]

APPS.HR_SFLUTIL_SS dependencies on DUAL

Line 191: from sys.dual

187: begin
188: --
189: select 1
190: into dummy
191: from sys.dual
192: where exists ( select null
193: from wf_notifications
194: where notification_id = nid
195: and status = 'OPEN'

Line 677: from sys.dual;

673: -- get the item key from sequence
674: -- Get the next item key from the sequence
675: select hr_workflow_item_key_s.nextval
676: into p_itemKey
677: from sys.dual;
678:
679: -- Create the Workflow Process
680: wf_engine.CreateProcess
681: (itemtype => p_itemType