APPS.CSE_ASSET_MOVE_PKG dependencies on CSI_SOURCE_IB_TYPES

Line 4053: csi_source_ib_types csit

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;
4057:

Line 4084: csi_source_ib_types csit

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;
4088: END;

Line 4114: csi_source_ib_types csit

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;
4118: END;

Line 4192: csi_source_ib_types csit

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;
4196: DEBUG( 'Bill Only Sql 2 '||l_change_owner );