APPS.CSE_ASSET_MOVE_PKG dependencies on CSI_T_TRANSACTION_LINES

Line 4043: FROM csi_t_txn_line_details ctld,csi_t_transaction_lines ctl

4039:
4040: BEGIN
4041: SELECT ctld.sub_type_id
4042: INTO l_sub_type_id
4043: FROM csi_t_txn_line_details ctld,csi_t_transaction_lines ctl
4044: WHERE ctld.transaction_line_id = ctl.transaction_line_id
4045: AND ctl. source_transaction_id = l_line_id
4046: AND ROWNUM=1;
4047:

Line 4072: csi_t_transaction_lines ctl

4068: SELECT nvl(src_change_owner, 'N')
4069: INTO l_change_owner
4070: FROM csi_ib_txn_types citt,
4071: csi_t_txn_line_details ctld,
4072: csi_t_transaction_lines ctl
4073: WHERE ctl.source_transaction_type_id = 51
4074: AND ctld.transaction_line_id = ctl.transaction_line_id
4075: AND ctld.source_transaction_flag = 'Y'
4076: AND ctld.csi_transaction_id = p_csi_txn_rec.transaction_id

Line 4177: csi_t_transaction_lines ctl

4173: SELECT nvl(src_change_owner, 'N')
4174: INTO l_change_owner
4175: FROM csi_ib_txn_types citt,
4176: csi_t_txn_line_details ctld,
4177: csi_t_transaction_lines ctl
4178: WHERE ctl.source_transaction_type_id = 51
4179: AND ctld.transaction_line_id = ctl.transaction_line_id
4180: AND ctld.source_transaction_flag = 'Y'
4181: AND ctld.csi_transaction_id = p_csi_txn_rec.transaction_id