APPS.CSI_T_VLDN_ROUTINES_PVT dependencies on CSI_II_RELATIONSHIPS

Line 534: FROM csi_ii_relationships

530: BEGIN
531:
532: SELECT object_id
533: INTO x_object_id
534: FROM csi_ii_relationships
535: WHERE relationship_id = p_csi_inst_rltns_id;
536:
537: x_return_status := fnd_api.g_ret_sts_success;
538:

Line 2147: l_iir_rec csi_ii_relationships%rowtype;

2143: IS
2144: l_routine_name CONSTANT VARCHAR2(30) := 'vldn.validate_inst_details';
2145: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2146: l_txn_rltns_rec csi_t_datastructures_grp.txn_ii_rltns_rec;
2147: l_iir_rec csi_ii_relationships%rowtype;
2148: l_subject_id NUMBER;
2149: l_object_id NUMBER;
2150: l_object_type VARCHAR2(30);
2151: l_subject_type VARCHAR2(30);

Line 2195: FROM csi_ii_relationships

2191: relationship_type_code
2192: INTO l_iir_rec.subject_id,
2193: l_iir_rec.object_id,
2194: l_iir_rec.relationship_type_code
2195: FROM csi_ii_relationships
2196: WHERE relationship_id = l_csi_rel_id
2197: AND sysdate between nvl(active_start_date, sysdate) and nvl(active_end_date,sysdate);
2198: EXCEPTION
2199: WHEN no_data_found THEN

Line 2252: FROM CSI_II_RELATIONSHIPS

2248:
2249: BEGIN
2250: SELECT 'Y'
2251: INTO l_found
2252: FROM CSI_II_RELATIONSHIPS
2253: WHERE relationship_type_code = 'COMPONENT-OF'
2254: AND subject_id = l_instance_id;
2255: EXCEPTION
2256: WHEN no_data_found THEN