APPS.CSI_INTERFACE_PKG dependencies on CSI_T_TXN_LINE_DETAILS

Line 2061: FROM CSI_T_TXN_LINE_DETAILS

2057: EXCEPTION
2058: WHEN NO_DATA_FOUND THEN
2059: BEGIN
2060: SELECT 'Y' INTO l_dummy
2061: FROM CSI_T_TXN_LINE_DETAILS
2062: WHERE txn_line_detail_id = l_rltns_tbl(l_ind).object_id
2063: AND instance_id IS NOT NULL;
2064:
2065: l_instance_found := TRUE;

Line 2097: FROM CSI_T_TXN_LINE_DETAILS

2093: EXCEPTION
2094: WHEN NO_DATA_FOUND THEN
2095: BEGIN
2096: SELECT 'Y' INTO l_dummy
2097: FROM CSI_T_TXN_LINE_DETAILS
2098: WHERE txn_line_detail_id = l_rltns_tbl(l_ind).subject_id
2099: AND instance_id IS NOT NULL;
2100:
2101: l_instance_found := TRUE;

Line 3181: FROM csi_t_txn_line_details

3177: SELECT location_id,
3178: location_type_code
3179: INTO l_location_id,
3180: l_location_type_code
3181: FROM csi_t_txn_line_details
3182: WHERE config_inst_hdr_id = partner_rec.inst_hdr_id
3183: AND config_inst_item_id = partner_rec.inst_item_id
3184: AND config_inst_rev_num = partner_rec.inst_rev_num;
3185:

Line 4020: FROM CSI_T_TXN_LINE_DETAILS

4016: WHEN no_data_found THEN
4017: BEGIN
4018: SELECT instance_id,active_end_date
4019: INTO l_sub_instance_id,l_sub_end_date --Fix for bug 5956280
4020: FROM CSI_T_TXN_LINE_DETAILS
4021: WHERE txn_line_detail_id = l_r_tbl(l_ii_ind).subject_id;
4022: EXCEPTION
4023: WHEN NO_DATA_FOUND THEN
4024: raise skip_the_relation;

Line 4044: FROM CSI_T_TXN_LINE_DETAILS

4040: WHEN no_data_found THEN
4041: BEGIN
4042: SELECT instance_id,active_end_date
4043: INTO l_obj_instance_id,l_obj_end_date --Fix for bug 5956280
4044: FROM CSI_T_TXN_LINE_DETAILS
4045: WHERE txn_line_detail_id = l_r_tbl(l_ii_ind).object_id;
4046: EXCEPTION
4047: WHEN NO_DATA_FOUND THEN
4048: raise skip_the_relation;