APPS.CSFW_SERVICEREQUEST_PUB dependencies on CS_INCIDENTS_ALL_B

Line 71: from cs_incidents_all_b where incident_id = v_incident_id;

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

Line 223: ( b_incident_id cs_incidents_all_b.incident_id%TYPE

219: IS
220:
221:
222: CURSOR c_incident
223: ( b_incident_id cs_incidents_all_b.incident_id%TYPE
224: )
225: IS
226: SELECT ci_all_b.incident_date incident_date -- bug # 4337147
227: , ci_all_b.incident_severity_id incident_severity_id

Line 231: FROM cs_incidents_all_b ci_all_b

227: , ci_all_b.incident_severity_id incident_severity_id
228: , ci_all_b.contract_service_id contract_service_id
229: , cit.business_process_id business_process_id
230: , ci_all_b.contract_number contract_number
231: FROM cs_incidents_all_b ci_all_b
232: , cs_incident_types cit
233: WHERE ci_all_b.incident_type_id = cit.incident_type_id
234: AND ci_all_b.incident_id = b_incident_id;
235:

Line 583: from cs_incidents_all_b where incident_id = v_incident_id;

579: cursor c_incident_type_id (v_incident_id number) is
580: select INCIDENT_TYPE_ID,
581: incident_number,
582: LAST_UPDATE_PROGRAM_CODE
583: from cs_incidents_all_b where incident_id = v_incident_id;
584:
585: r_incident_type_id c_incident_type_id%ROWTYPE;
586:
587: BEGIN