APPS.CSE_ASSET_MOVE_PKG dependencies on CSI_IB_TXN_TYPES

Line 4052: FROM csi_ib_txn_types citt,

4048: EXCEPTION
4049: WHEN NO_DATA_FOUND THEN
4050: SELECT nvl(citt.sub_type_id, -1)
4051: INTO l_sub_type_id
4052: FROM csi_ib_txn_types citt,
4053: csi_source_ib_types csit
4054: WHERE csit.transaction_type_id = 51
4055: AND csit.default_flag = 'Y'
4056: and citt.sub_type_id = csit.sub_type_id;

Line 4070: FROM csi_ib_txn_types citt,

4066: IF p_csi_txn_rec.transaction_type_id = 51 THEN
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

Line 4083: FROM csi_ib_txn_types citt,

4079: EXCEPTION
4080: WHEN no_data_found THEN
4081: SELECT nvl(src_change_owner, 'N')
4082: INTO l_change_owner
4083: FROM csi_ib_txn_types citt,
4084: csi_source_ib_types csit
4085: WHERE csit.transaction_type_id = 51
4086: AND csit.default_flag = 'Y'
4087: and citt.sub_type_id = csit.sub_type_id;

Line 4107: FROM csi_ib_txn_types

4103:
4104: BEGIN
4105: SELECT nvl(src_change_owner, 'N')
4106: INTO l_change_owner
4107: FROM csi_ib_txn_types
4108: WHERE sub_type_id = p_csi_txn_rec.txn_sub_type_id;
4109: EXCEPTION
4110: WHEN no_data_found THEN
4111: SELECT nvl(src_change_owner, 'N')

Line 4113: FROM csi_ib_txn_types citt,

4109: EXCEPTION
4110: WHEN no_data_found THEN
4111: SELECT nvl(src_change_owner, 'N')
4112: INTO l_change_owner
4113: FROM csi_ib_txn_types citt,
4114: csi_source_ib_types csit
4115: WHERE csit.transaction_type_id = 53
4116: AND csit.default_flag = 'Y'
4117: AND citt.sub_type_id = csit.sub_type_id;

Line 4175: FROM csi_ib_txn_types citt,

4171:
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

Line 4191: FROM csi_ib_txn_types citt,

4187: WHEN no_data_found THEN
4188: DEBUG( 'Bill Only No Data Found' );
4189: SELECT nvl(src_change_owner, 'N')
4190: INTO l_change_owner
4191: FROM csi_ib_txn_types citt,
4192: csi_source_ib_types csit
4193: WHERE csit.transaction_type_id = 51
4194: AND csit.default_flag = 'Y'
4195: and citt.sub_type_id = csit.sub_type_id;