DBA Data[Home] [Help]

APPS.CS_INCIDENTLINKS_PVT dependencies on CS_SR_LINK_TYPES_B

Line 759: from cs_sr_link_types_b

755: -- link_type_id should be valid for control to come to this point. If for some reason it
756: -- is not, the when others exception will be raised.
757: select reciprocal_link_type_id
758: into l_reciprocal_link_type_id
759: from cs_sr_link_types_b
760: where link_type_id = p_link_rec.link_type_id;
761:
762: -- For bugs 2972584 and 2972611
763: -- Reset the old columns to NULL

Line 2229: from cs_sr_link_types_b

2225: -- fetch the reciprocal link_type_id to be passed to the BES API. This select has to be
2226: -- a success, but to avoid no data found, using max
2227: select max(reciprocal_link_type_id)
2228: into l_reciprocal_link_type_id
2229: from cs_sr_link_types_b
2230: where link_type_id = c1rec.link_type_id;
2231:
2232: l_link_rec.OBJECT_ID := c1rec.subject_id;
2233: l_link_rec.OBJECT_NUMBER := l_subject_number;