APPS.CS_WF_EVENT_PKG dependencies on WF_ACTIVITIES

Line 77: l_wf_activity_name WF_ACTIVITIES.name%TYPE;

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
81: from WF_ACTIVITIES wfa

Line 81: from WF_ACTIVITIES wfa

77: l_wf_activity_name WF_ACTIVITIES.name%TYPE;
78:
79: CURSOR sel_workflow_act_csr IS
80: select wfa.name
81: from WF_ACTIVITIES wfa
82: where wfa.item_type = 'SERVEREQ'
83: and wfa.type ='EVENT'
84: and wfa.name = l_wf_proc_activity_name;
85:

Line 304: l_wf_activity_name WF_ACTIVITIES.name%TYPE;

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
308: SELECT t1.workflow

Line 328: FROM WF_ACTIVITIES wfa

324: AND end_date IS NULL;
325:
326: CURSOR sel_workflow_act_csr IS
327: SELECT wfa.name
328: FROM WF_ACTIVITIES wfa
329: WHERE wfa.item_type = 'SERVEREQ'
330: AND wfa.type ='EVENT'
331: AND wfa.name = l_wf_proc_activity_name;
332: