APPS.CSD_ISUP_DEPOT_WF_PVT dependencies on WF_ROLES

Line 194: FROM wf_roles wr,

190: AND ro.repair_line_id = p_repair_line_id;
191:
192: CURSOR get_wf_role (p_repair_line_id IN NUMBER) IS
193: SELECT wr.name
194: FROM wf_roles wr,
195: cs_incidents_v sr,
196: csd_repairs ro
197: WHERE ro.repair_line_id = p_repair_line_id
198: AND ro.incident_id = sr.incident_id

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

581:
582:
583: IF x_return_status = 'S' THEN
584:
585: -- Derive the wf roles for the Contact id
586: OPEN get_wf_role (x_repair_line_id);
587: FETCH get_wf_role INTO l_wf_role;
588: CLOSE get_wf_role;
589: