APPS.CSI_T_VLDN_ROUTINES_PVT dependencies on CSI_T_II_RELATIONSHIPS

Line 256: FROM csi_t_ii_relationships

252: BEGIN
253:
254: SELECT 'X'
255: INTO l_found
256: FROM csi_t_ii_relationships
257: WHERE txn_relationship_id = p_txn_relationship_id;
258:
259: x_return_status := fnd_api.g_ret_sts_success;
260:

Line 2021: FROM csi_t_ii_relationships

2017: c_object_id IN NUMBER ,
2018: c_relationship_type_code IN VARCHAR2)
2019: IS
2020: SELECT txn_relationship_id , object_type, subject_type
2021: FROM csi_t_ii_relationships
2022: WHERE subject_id = c_subject_id
2023: AND object_id = c_object_id
2024: AND relationship_type_code = c_relationship_type_code
2025: AND NVL(active_end_date , SYSDATE) >= SYSDATE ;