DBA Data[Home] [Help]

APPS.JTF_FM_REQUEST_GRP_WF dependencies on DUAL

Line 48: FROM sys.dual;

44: x_requester_disp_name VARCHAR2(30);
45: BEGIN
46: SELECT TO_CHAR(JTF_FM_WORKFLOW_S.nextval)
47: INTO v_ItemKey
48: FROM sys.dual;
49:
50: SELECT orig_system_id
51: INTO x_orig_system_id
52: FROM wf_users

Line 54: FROM DUAL);

50: SELECT orig_system_id
51: INTO x_orig_system_id
52: FROM wf_users
53: WHERE name = ( SELECT user
54: FROM DUAL);
55:
56: wf_engine.CreateProcess( ItemType => v_ItemType,
57: ItemKey => v_ItemKey,
58: process => 'SUB_REQ' );