DBA Data[Home] [Help]

APPS.CS_INCIDENTLINKS_PUB dependencies on CS_INCIDENTS_ALL_B

Line 1310: -- derive the value of from_incident_id from the cs_incidents_all_b table based on the value of from_incident_number

1306: -- For Bugs 2972584 and 2972611
1307: -- Populate the record type variable with the values that have been passed in
1308:
1309: -- If p_from_incident_number is passed, and p_from_incident_id is NULL, then
1310: -- derive the value of from_incident_id from the cs_incidents_all_b table based on the value of from_incident_number
1311: If (p_from_incident_id IS NULL) And (p_from_incident_number IS NOT NULL) Then
1312: Begin
1313: Select incident_id
1314: Into l_from_incident_id

Line 1315: From cs_incidents_all_b

1311: If (p_from_incident_id IS NULL) And (p_from_incident_number IS NOT NULL) Then
1312: Begin
1313: Select incident_id
1314: Into l_from_incident_id
1315: From cs_incidents_all_b
1316: Where incident_number = p_from_incident_number;
1317: Exception
1318: When No_Data_Found Then
1319: Null;