DBA Data[Home] [Help]

APPS.CS_INCIDENTLINKS_UTIL dependencies on CS_SR_LINK_VALID_OBJ

Line 84: from cs_sr_link_valid_obj

80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81:
82: select count(*)
83: into l_dummy
84: from cs_sr_link_valid_obj
85: where subject_type = p_subject_type
86: and object_type = p_object_type
87: and link_type_id = p_link_type_id
88: and SYSDATE between nvl(start_date_active, SYSDATE)

Line 106: from cs_sr_link_valid_obj

102: l_dummy := 0;
103:
104: select count(*)
105: into l_dummy
106: from cs_sr_link_valid_obj
107: where subject_type = p_object_type
108: and object_type = p_subject_type
109: and link_type_id = ( select reciprocal_link_type_id
110: from cs_sr_link_types_b