APPS.CSI_INTERFACE_PKG dependencies on CSI_T_TXN_LINE_DETAILS

Line 2032: FROM CSI_T_TXN_LINE_DETAILS

2028: EXCEPTION
2029: WHEN NO_DATA_FOUND THEN
2030: BEGIN
2031: SELECT 'Y' INTO l_dummy
2032: FROM CSI_T_TXN_LINE_DETAILS
2033: WHERE txn_line_detail_id = l_rltns_tbl(l_ind).object_id
2034: AND instance_id IS NOT NULL;
2035:
2036: l_instance_found := TRUE;

Line 2068: FROM CSI_T_TXN_LINE_DETAILS

2064: EXCEPTION
2065: WHEN NO_DATA_FOUND THEN
2066: BEGIN
2067: SELECT 'Y' INTO l_dummy
2068: FROM CSI_T_TXN_LINE_DETAILS
2069: WHERE txn_line_detail_id = l_rltns_tbl(l_ind).subject_id
2070: AND instance_id IS NOT NULL;
2071:
2072: l_instance_found := TRUE;

Line 3147: FROM csi_t_txn_line_details

3143: SELECT location_id,
3144: location_type_code
3145: INTO l_location_id,
3146: l_location_type_code
3147: FROM csi_t_txn_line_details
3148: WHERE config_inst_hdr_id = partner_rec.inst_hdr_id
3149: AND config_inst_item_id = partner_rec.inst_item_id
3150: AND config_inst_rev_num = partner_rec.inst_rev_num;
3151:

Line 3928: FROM CSI_T_TXN_LINE_DETAILS

3924: WHEN no_data_found THEN
3925: BEGIN
3926: SELECT instance_id,active_end_date
3927: INTO l_sub_instance_id,l_sub_end_date --Fix for bug 5956280
3928: FROM CSI_T_TXN_LINE_DETAILS
3929: WHERE txn_line_detail_id = l_r_tbl(l_ii_ind).subject_id;
3930: EXCEPTION
3931: WHEN NO_DATA_FOUND THEN
3932: raise skip_the_relation;

Line 3952: FROM CSI_T_TXN_LINE_DETAILS

3948: WHEN no_data_found THEN
3949: BEGIN
3950: SELECT instance_id,active_end_date
3951: INTO l_obj_instance_id,l_obj_end_date --Fix for bug 5956280
3952: FROM CSI_T_TXN_LINE_DETAILS
3953: WHERE txn_line_detail_id = l_r_tbl(l_ii_ind).object_id;
3954: EXCEPTION
3955: WHEN NO_DATA_FOUND THEN
3956: raise skip_the_relation;