APPS.CSI_INV_TRXS_PKG dependencies on CSI_TXN_TYPES

Line 4222: FROM CSI_Txn_Types ctt,

4218: P_App_Short_Name IN VARCHAR2) RETURN NUMBER IS
4219: l_Txn_Type_Id NUMBER;
4220: CURSOR Txn_Type_Cur IS
4221: SELECT ctt.Transaction_Type_Id Transaction_Type_Id
4222: FROM CSI_Txn_Types ctt,
4223: FND_Application fa
4224: WHERE ctt.Source_Transaction_Type = P_Txn_Type
4225: AND fa.application_id = ctt.Source_Application_ID
4226: AND fa.Application_Short_Name = P_App_Short_Name;

Line 4238: FROM CSI_Txn_Types

4234: FUNCTION Get_Txn_Type_Code(P_Txn_Id IN NUMBER) RETURN VARCHAR2 IS
4235: l_Txn_Type_Code VARCHAR2(100);
4236: CURSOR Txn_Type_Id_Cur IS
4237: SELECT Source_Transaction_Type
4238: FROM CSI_Txn_Types
4239: WHERE Transaction_Type_Id = P_Txn_Id;
4240: BEGIN
4241: OPEN Txn_Type_Id_Cur;
4242: FETCH Txn_Type_Id_Cur INTO l_Txn_Type_Code;