APPS.CSD_WF_PROCESS_PVT dependencies on WF_ROLES

Line 48: from wf_roles wr,

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

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

67: itemkey => itemkey,
68: aname => 'CSD_REPAIR_LINE_ID');
69:
70: --
71: -- Derive the wf roles for the Contact id
72: --
73: Open get_wf_role (l_repair_line_id);
74: Fetch get_wf_role into l_wf_role;
75: Close get_wf_role;

Line 198: from wf_roles wr,

194:
195: -- cursor to see if a role exists for the SR contact.
196: Cursor get_wf_role (p_repair_line_id in number) is
197: Select wr.name
198: from wf_roles wr,
199: cs_incidents_v sr,
200: csd_repairs ro
201: where ro.repair_line_id = p_repair_line_id
202: and ro.incident_id = sr.incident_id

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

216: itemkey => itemkey,
217: aname => 'CSD_REPAIR_LINE_ID');
218:
219: --
220: -- Derive the wf roles for the Contact id
221: --
222: Open get_wf_role (l_repair_line_id);
223: Fetch get_wf_role into l_wf_role;
224: Close get_wf_role;

Line 339: From wf_roles wr,

335: Select wr.name, wr.email_address, sr.incident_number,
336: ro.repair_number, ro.serial_number,
337: ro.flow_status, ro.item,
338: cjr.source_first_name, cjr.source_last_name
339: From wf_roles wr,
340: csd_incidents_v sr,
341: csd_repairs_v ro,
342: CS_JTF_RS_RESOURCE_EXTNS_SEC cjr
343: Where ro.repair_line_id = p_repair_line_id