APPS.CSI_T_TXN_RLTNSHPS_PVT dependencies on CSI_T_TXN_LINE_DETAILS

Line 746: FROM csi_t_transaction_lines tl, csi_t_txn_line_details tld

742: BEGIN
743: IF l_iir_rec.subject_type = 'T' THEN
744: SELECT tl.processing_status
745: INTO l_processing_status
746: FROM csi_t_transaction_lines tl, csi_t_txn_line_details tld
747: WHERE tld.txn_line_detail_id = l_iir_rec.subject_id
748: AND tl.transaction_line_id = l_iir_rec.transaction_line_id
749: AND tl.transaction_line_id = tld.transaction_line_id;
750:

Line 762: FROM csi_t_transaction_lines tl, csi_t_txn_line_details tld

758:
759: ELSIF l_iir_rec.object_type = 'T' THEN
760: SELECT tl.processing_status
761: INTO l_processing_status
762: FROM csi_t_transaction_lines tl, csi_t_txn_line_details tld
763: WHERE tld.txn_line_detail_id = l_iir_rec.object_id
764: AND tl.transaction_line_id = l_iir_rec.transaction_line_id
765: AND tl.transaction_line_id = tld.transaction_line_id;
766:

Line 779: FROM csi_t_transaction_lines tl, csi_t_txn_line_details tld

775: END IF;
776: ELSIF l_iir_rec.object_type = 'T' THEN
777: SELECT tl.processing_status
778: INTO l_processing_status
779: FROM csi_t_transaction_lines tl, csi_t_txn_line_details tld
780: WHERE tld.txn_line_detail_id = l_iir_rec.object_id
781: AND tl.transaction_line_id = l_iir_rec.transaction_line_id
782: AND tl.transaction_line_id = tld.transaction_line_id;
783: