APPS.CSI_T_TXN_RLTNSHPS_PVT dependencies on CSI_T_TRANSACTION_LINES

Line 487: l_processing_status csi_t_transaction_lines.processing_status%TYPE;

483: l_api_version CONSTANT NUMBER := 1.0;
484: l_debug_level NUMBER;
485:
486: l_return_status VARCHAR2(1);
487: l_processing_status csi_t_transaction_lines.processing_status%TYPE;
488: --l_iir_rec csi_t_ii_relationships%ROWTYPE; M-M change . referencing datastructure record instead
489: l_iir_rec csi_t_datastructures_grp.txn_ii_rltns_rec;
490: l_txn_line_dtl_rec1 csi_t_datastructures_grp.txn_line_detail_rec;
491: l_txn_line_dtl_rec2 csi_t_datastructures_grp.txn_line_detail_rec;

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: