DBA Data[Home] [Help]

APPS.CS_INCIDENTLINKS_UTIL dependencies on CS_SR_LINK_TYPES_B

Line 21: from cs_sr_link_types_b

17:
18: -- the nvl is needed coz either one of the parameters can be passed.
19: cursor c1 is
20: select link_type_id
21: from cs_sr_link_types_b
22: where link_type_id = p_link_type_id
23: and SYSDATE between nvl(start_date_active, SYSDATE)
24: and nvl(end_date_active , SYSDATE);
25:

Line 110: from cs_sr_link_types_b

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
111: where link_type_id = p_link_type_id )
112: and SYSDATE between nvl(start_date_active, SYSDATE)
113: and nvl(end_date_active , SYSDATE );
114: