APPS.PER_MAINTAIN_TASKFLOW dependencies on HR_WORKFLOWS

Line 25: FROM hr_workflows

21: -- Find the workflow_id that corresponds to p_taskflow_name (workflow name).
22: --
23: SELECT workflow_id
24: INTO l_workflow_id
25: FROM hr_workflows
26: WHERE workflow_name = p_taskflow_name;
27: --
28: -- For each node usage attached to a taskflow delete the navigation paths
29: -- then delete the node usage record.

Line 42: DELETE FROM hr_workflows

38: END LOOP;
39: --
40: -- Delete the taskflow.
41: --
42: DELETE FROM hr_workflows
43: WHERE workflow_id = l_workflow_id;
44: END delete_taskflow;
45:
46: --