APPS.CSE_ASSET_UTIL_PKG dependencies on CSI_IB_TXN_TYPES

Line 1102: FROM csi_ib_txn_types citt,

1098: EXCEPTION
1099: WHEN NO_DATA_FOUND THEN
1100: SELECT nvl(citt.sub_type_id, -1)
1101: INTO l_sub_type_id
1102: FROM csi_ib_txn_types citt,
1103: csi_source_ib_types csit
1104: WHERE csit.transaction_type_id = 51
1105: AND csit.default_flag = 'Y'
1106: and citt.sub_type_id = csit.sub_type_id;

Line 1626: csi_ib_txn_types ctst

1622:
1623: CURSOR csi_sub_type_cur (c_transaction_id IN NUMBER) IS
1624: SELECT ctst.src_change_owner
1625: FROM csi_t_txn_line_details cttld,
1626: csi_ib_txn_types ctst
1627: WHERE cttld.source_transaction_flag = 'Y'
1628: AND cttld.csi_transaction_id = c_transaction_id
1629: AND cttld.sub_type_id = ctst.sub_type_id;
1630:

Line 1774: FROM csi_ib_txn_types citt,

1770: EXCEPTION
1771: WHEN NO_DATA_FOUND THEN
1772: SELECT nvl(citt.sub_type_id, -1)
1773: INTO l_sub_type_id
1774: FROM csi_ib_txn_types citt,
1775: csi_source_ib_types csit
1776: WHERE csit.transaction_type_id = 51
1777: AND csit.default_flag = 'Y'
1778: and citt.sub_type_id = csit.sub_type_id;