DBA Data[Home] [Help]

APPS.CSE_ASSET_MOVE_PKG dependencies on CSI_SOURCE_IB_TYPES

Line 3884: csi_source_ib_types csit

3880: WHEN no_data_found THEN
3881: SELECT nvl(src_change_owner, 'N')
3882: INTO l_change_owner
3883: FROM csi_ib_txn_types citt,
3884: csi_source_ib_types csit
3885: WHERE csit.transaction_type_id = 51
3886: AND csit.default_flag = 'Y'
3887: and citt.sub_type_id = csit.sub_type_id;
3888: END;

Line 3908: csi_source_ib_types csit

3904: WHEN no_data_found THEN
3905: SELECT nvl(src_change_owner, 'N')
3906: INTO l_change_owner
3907: FROM csi_ib_txn_types citt,
3908: csi_source_ib_types csit
3909: WHERE csit.transaction_type_id = 53
3910: AND csit.default_flag = 'Y'
3911: AND citt.sub_type_id = csit.sub_type_id;
3912: END;

Line 3975: csi_source_ib_types csit

3971: DEBUG( 'Bill Only No Data Found' );
3972: SELECT nvl(src_change_owner, 'N')
3973: INTO l_change_owner
3974: FROM csi_ib_txn_types citt,
3975: csi_source_ib_types csit
3976: WHERE csit.transaction_type_id = 51
3977: AND csit.default_flag = 'Y'
3978: and citt.sub_type_id = csit.sub_type_id;
3979: DEBUG( 'Bill Only Sql 2 '||l_change_owner );