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 2120: l_iir_rec csi_ii_relationships%rowtype;

2116: IS
2117: l_routine_name CONSTANT VARCHAR2(30) := 'vldn.validate_inst_details';
2118: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2119: l_txn_rltns_rec csi_t_datastructures_grp.txn_ii_rltns_rec;
2120: l_iir_rec csi_ii_relationships%rowtype;
2121: l_subject_id NUMBER;
2122: l_object_id NUMBER;
2123: l_object_type VARCHAR2(30);
2124: l_subject_type VARCHAR2(30);

Line 2168: FROM csi_ii_relationships

2164: relationship_type_code
2165: INTO l_iir_rec.subject_id,
2166: l_iir_rec.object_id,
2167: l_iir_rec.relationship_type_code
2168: FROM csi_ii_relationships
2169: WHERE relationship_id = l_csi_rel_id
2170: AND sysdate between nvl(active_start_date, sysdate) and nvl(active_end_date,sysdate);
2171: EXCEPTION
2172: WHEN no_data_found THEN

Line 2225: FROM CSI_II_RELATIONSHIPS

2221:
2222: BEGIN
2223: SELECT 'Y'
2224: INTO l_found
2225: FROM CSI_II_RELATIONSHIPS
2226: WHERE relationship_type_code = 'COMPONENT-OF'
2227: AND subject_id = l_instance_id;
2228: EXCEPTION
2229: WHEN no_data_found THEN