APPS.CS_WF_EVENT_PKG dependencies on WF_PROCESS_ACTIVITIES

Line 76: l_wf_proc_activity_name wf_process_activities.ACTIVITY_NAME%TYPE;

72:
73:
74: l_process_name VARCHAR2(30);
75:
76: l_wf_proc_activity_name wf_process_activities.ACTIVITY_NAME%TYPE;
77: l_wf_activity_name WF_ACTIVITIES.name%TYPE;
78:
79: CURSOR sel_workflow_act_csr IS
80: select wfa.name

Line 90: from wf_process_activities wfpa

86:
87: -- get the Name of the Start activity for the latest workflow process version
88: CURSOR sel_workflow_proc_act_csr IS
89: select wfpa.ACTIVITY_NAME
90: from wf_process_activities wfpa
91: where wfpa.PROCESS_ITEM_TYPE = 'SERVEREQ'
92: and wfpa.PROCESS_NAME = l_process_name
93: and wfpa.START_END = 'START'
94: ORDER BY wfpa.process_version DESC;

Line 303: l_wf_proc_activity_name wf_process_activities.ACTIVITY_NAME%TYPE;

299: l_initiator_role VARCHAR2(100);
300: l_dummy VARCHAR2(240);
301: -- End Bug 12411987
302:
303: l_wf_proc_activity_name wf_process_activities.ACTIVITY_NAME%TYPE;
304: l_wf_activity_name WF_ACTIVITIES.name%TYPE;
305:
306:
307: CURSOR sel_workflow_csr IS

Line 337: from wf_process_activities wfpa

333:
334: -- get the Name of the Start activity for the latest workflow process version
335: CURSOR sel_workflow_proc_act_csr IS
336: select wfpa.ACTIVITY_NAME
337: from wf_process_activities wfpa
338: where wfpa.PROCESS_ITEM_TYPE = 'SERVEREQ'
339: and wfpa.PROCESS_NAME = l_process_name
340: and wfpa.START_END = 'START'
341: ORDER BY wfpa.process_version DESC;