DBA Data[Home] [Help]

APPS.CSE_UTIL_PKG dependencies on CSI_TXN_TYPES

Line 908: FROM CSI_Txn_Types ctt,

904: P_App_Short_Name IN VARCHAR2) RETURN NUMBER IS
905: l_Txn_Type_Id NUMBER;
906: CURSOR Txn_Type_Cur IS
907: SELECT ctt.Transaction_Type_Id Transaction_Type_Id
908: FROM CSI_Txn_Types ctt,
909: FND_Application fa
910: WHERE ctt.Source_Transaction_Type = P_Txn_Type
911: AND fa.application_id = ctt.Source_Application_ID
912: AND fa.Application_Short_Name = P_App_Short_Name;

Line 924: FROM CSI_Txn_Types

920: FUNCTION Get_Txn_Type_Code(P_Txn_Id IN NUMBER) RETURN VARCHAR2 IS
921: l_Txn_Type_Code VARCHAR2(100);
922: CURSOR Txn_Type_Id_Cur IS
923: SELECT Source_Transaction_Type
924: FROM CSI_Txn_Types
925: WHERE Transaction_Type_Id = P_Txn_Id;
926: BEGIN
927: OPEN Txn_Type_Id_Cur;
928: FETCH Txn_Type_Id_Cur INTO l_Txn_Type_Code;