DBA Data[Home] [Help]

APPS.CSD_WF_PROCESS_PVT dependencies on CS_INCIDENTS_V

Line 47: cs_incidents_v sr,

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