DBA Data[Home] [Help]

APPS.CSD_WF_PROCESS_PVT dependencies on CS_INCIDENTS_V

Line 49: cs_incidents_v sr,

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

Line 199: cs_incidents_v sr,

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