APPS.CSD_PROCESS_UTIL dependencies on CS_INCIDENTS_ALL_B

Line 149: from cs_incidents_all_b

145: BEGIN
146:
147: select 'X'
148: into l_dummy
149: from cs_incidents_all_b
150: where incident_id = p_incident_id;
151: -- swai: bug 7273784 - start_date_active and end_date_active
152: -- are obsoleted by service team
153: -- and sysdate between nvl(start_date_active,sysdate)

Line 3732: cs_incidents_all_b b

3728:
3729: select b.org_id
3730: into l_org_id
3731: from csd_repairs a,
3732: cs_incidents_all_b b
3733: where a.incident_id = b.incident_id
3734: and a.repair_line_id = p_repair_line_id;
3735:
3736: RETURN l_org_id;

Line 3888: from cs_incidents_all_b a,

3884:
3885: -- Forward port bug# 2756313
3886: /* select b.business_process_id
3887: into l_bus_process_id
3888: from cs_incidents_all_b a,
3889: cs_incident_types_b b
3890: where a.incident_type_id = b.incident_type_id
3891: and a.incident_id = p_incident_id;
3892: */

Line 5778: cs_incidents_all_b sr -- swai: bug 5931926

5774: from csd_repairs dr,
5775: cs_estimate_details ced,
5776: oe_order_headers_all ooh,
5777: oe_order_types_v oot,
5778: cs_incidents_all_b sr -- swai: bug 5931926
5779: where dr.repair_line_id = p_repair_line_id
5780: and ced.incident_id = dr.incident_id
5781: and ced.order_header_id is not null
5782: and ooh.open_flag = 'Y'

Line 5813: cs_incidents_all_b sr -- swai: bug 5931926

5809: from csd_repairs dr,
5810: cs_estimate_details ced,
5811: oe_order_headers_all ooh,
5812: oe_order_types_v oot,
5813: cs_incidents_all_b sr -- swai: bug 5931926
5814: where dr.repair_line_id = p_repair_line_id
5815: and ced.incident_id = dr.incident_id
5816: and ced.order_header_id is not null
5817: and ooh.open_flag = 'Y'