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:
4067: BEGIN
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'
4172: BEGIN
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'