APPS.CSFW_SERVICEREQUEST_PUB dependencies on CS_INCIDENTS_ALL_B

Line 70: from cs_incidents_all_b where incident_id = v_incident_id;

66: cursor c_incident_type_id (v_incident_id number) is
67: select INCIDENT_TYPE_ID,
68: incident_number,
69: LAST_UPDATE_PROGRAM_CODE
70: from cs_incidents_all_b where incident_id = v_incident_id;
71:
72: r_incident_type_id c_incident_type_id%ROWTYPE;
73:
74: BEGIN

Line 217: ( b_incident_id cs_incidents_all_b.incident_id%TYPE

213: IS
214:
215:
216: CURSOR c_incident
217: ( b_incident_id cs_incidents_all_b.incident_id%TYPE
218: )
219: IS
220: SELECT ci_all_b.incident_date incident_date -- bug # 4337147
221: , ci_all_b.incident_severity_id incident_severity_id

Line 225: FROM cs_incidents_all_b ci_all_b

221: , ci_all_b.incident_severity_id incident_severity_id
222: , ci_all_b.contract_service_id contract_service_id
223: , cit.business_process_id business_process_id
224: , ci_all_b.contract_number contract_number
225: FROM cs_incidents_all_b ci_all_b
226: , cs_incident_types cit
227: WHERE ci_all_b.incident_type_id = cit.incident_type_id
228: AND ci_all_b.incident_id = b_incident_id;
229:

Line 568: from cs_incidents_all_b where incident_id = v_incident_id;

564: cursor c_incident_type_id (v_incident_id number) is
565: select INCIDENT_TYPE_ID,
566: incident_number,
567: LAST_UPDATE_PROGRAM_CODE
568: from cs_incidents_all_b where incident_id = v_incident_id;
569:
570: r_incident_type_id c_incident_type_id%ROWTYPE;
571:
572: BEGIN