DBA Data[Home] [Help]

APPS.CSD_ISUP_DEPOT_WF_PVT dependencies on WF_ROLES

Line 198: from wf_roles wr,

194: AND ro.repair_line_id = p_repair_line_id;
195:
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 447: -- Derive the wf roles for the Contact id

443:
444:
445: if x_return_status = 'S' then
446:
447: -- Derive the wf roles for the Contact id
448: Open get_wf_role (x_repair_line_id);
449: Fetch get_wf_role into l_wf_role;
450: Close get_wf_role;
451: