DBA Data[Home] [Help]

APPS.CSD_WF_PROCESS_PVT dependencies on WF_ROLES

Line 46: from wf_roles wr,

42:
43: -- cursor to see if a role exist for the SR contact.
44: Cursor get_wf_role (p_repair_line_id in number) is
45: Select wr.name
46: from wf_roles wr,
47: cs_incidents_v sr,
48: csd_repairs ro
49: where ro.repair_line_id = p_repair_line_id
50: and ro.incident_id = sr.incident_id

Line 67: -- Derive the wf roles for the Contact id

63: itemkey => itemkey,
64: aname => 'CSD_REPAIR_LINE_ID');
65:
66: --
67: -- Derive the wf roles for the Contact id
68: --
69: Open get_wf_role (l_repair_line_id);
70: Fetch get_wf_role into l_wf_role;
71: Close get_wf_role;