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 1994: FROM csi_t_ii_relationships

1990: c_object_id IN NUMBER ,
1991: c_relationship_type_code IN VARCHAR2)
1992: IS
1993: SELECT txn_relationship_id , object_type, subject_type
1994: FROM csi_t_ii_relationships
1995: WHERE subject_id = c_subject_id
1996: AND object_id = c_object_id
1997: AND relationship_type_code = c_relationship_type_code
1998: AND NVL(active_end_date , SYSDATE) >= SYSDATE ;