APPS.CSE_ASSET_MOVE_PKG dependencies on CSI_IB_TXN_TYPES

Line 3870: FROM csi_ib_txn_types citt,

3866: IF p_csi_txn_rec.transaction_type_id = 51 THEN
3867: BEGIN
3868: SELECT nvl(src_change_owner, 'N')
3869: INTO l_change_owner
3870: FROM csi_ib_txn_types citt,
3871: csi_t_txn_line_details ctld,
3872: csi_t_transaction_lines ctl
3873: WHERE ctl.source_transaction_type_id = 51
3874: AND ctld.transaction_line_id = ctl.transaction_line_id

Line 3883: FROM csi_ib_txn_types citt,

3879: EXCEPTION
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;

Line 3901: FROM csi_ib_txn_types

3897:
3898: BEGIN
3899: SELECT nvl(src_change_owner, 'N')
3900: INTO l_change_owner
3901: FROM csi_ib_txn_types
3902: WHERE sub_type_id = p_csi_txn_rec.txn_sub_type_id;
3903: EXCEPTION
3904: WHEN no_data_found THEN
3905: SELECT nvl(src_change_owner, 'N')

Line 3907: FROM csi_ib_txn_types citt,

3903: EXCEPTION
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;

Line 3958: FROM csi_ib_txn_types citt,

3954:
3955: BEGIN
3956: SELECT nvl(src_change_owner, 'N')
3957: INTO l_change_owner
3958: FROM csi_ib_txn_types citt,
3959: csi_t_txn_line_details ctld,
3960: csi_t_transaction_lines ctl
3961: WHERE ctl.source_transaction_type_id = 51
3962: AND ctld.transaction_line_id = ctl.transaction_line_id

Line 3974: FROM csi_ib_txn_types citt,

3970: WHEN no_data_found THEN
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;