APPS.CSD_WF_PROCESS_PVT dependencies on CSD_REPAIRS

Line 39: csd_repairs ro

35: ro.serial_number,
36: sr.item,
37: decode(sr.contact_type,'EMPLOYEE',sr.first_name||' '||sr.last_name,sr.full_name) contact_name
38: from csd_incidents_v sr,
39: csd_repairs ro
40: where ro.incident_id = sr.incident_id
41: and ro.repair_line_id = p_repair_line_id;
42:
43: -- cursor to see if a role exist for the SR contact.

Line 48: csd_repairs ro

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
51: and wr.orig_system_id = sr.contact_party_id
52: and wr.orig_system = 'HZ_PARTY'